SingleStore
Query your SingleStore database in English.
This plugin allows you to query your SingleStore database in English. With just a few simple commands, you can easily retrieve data and perform operations on your database. Say goodbye to complex SQL queries and hello to a more intuitive way of interacting with your data. Whether you're a beginner or an experienced database user, this plugin makes database management a breeze. Get ready to unlock the power of your SingleStore database with this easy-to-use plugin!
How to
Comments (0)
Try it
API docs
Learn how to use SingleStore effectively! Here are a few example prompts, tips, and the documentation of available commands.
Example prompts
-
Prompt 1: "Can you help me query my SingleStore database in English?"
-
Prompt 2: "I need to connect to the Mongo database, can you provide a link?"
-
Prompt 3: "What is the structure of my Mongo (Kai) database?"
-
Prompt 4: "Execute a MongoDB aggregate query on my Mongo (Kai) database."
-
Prompt 5: "Get the schema of my MySQL database."
Features and commands
| Feature/Command | Description |
|---|---|
db_type | This command retrieves the database type (MySQL or Mongo) that is currently active for the user. |
db_connect_kai | This command provides a link to the Mongo (Kai) database connection configuration page. The link can only be used once and expires after 5 minutes. |
db_connect_mysql | This command provides a link to the MySQL database connection configuration page. The link can only be used once and expires after 5 minutes. |
kai_summaries | This command retrieves the collection schema of the Mongo (Kai) database, including the collection names and corresponding field types. |
kai_aggregate | This command executes a MongoDB aggregate query using PyMongo to retrieve data from the Mongo (Kai) database. You need to specify the collection name and the query to be executed. |
sql_summaries | This command retrieves the collection schema of the MySQL database, including the collection names and corresponding field types. |
sql_query | This command executes a MySQL query to retrieve data from the MySQL database. You need to provide the query to be executed. |
notebook_create | This command creates a Jupyter Notebook file (.ipynb) with the specified name and content. It provides a Markdown link to download the file. You can optionally specify a display name for the notebook. |
notebook_all | This command lists all the available Jupyter Notebooks. |