Logo and icon for SingleStore, a ChatGPT plugin with description: Query your SingleStore database in English.. Find out more on Plugin Surf, the best plugin database.

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!

Learn how to use SingleStore effectively! Here are a few example prompts, tips, and the documentation of available commands.

Example prompts

  1. Prompt 1: "Can you help me query my SingleStore database in English?"

  2. Prompt 2: "I need to connect to the Mongo database, can you provide a link?"

  3. Prompt 3: "What is the structure of my Mongo (Kai) database?"

  4. Prompt 4: "Execute a MongoDB aggregate query on my Mongo (Kai) database."

  5. Prompt 5: "Get the schema of my MySQL database."

Features and commands

Feature/CommandDescription
db_typeThis command retrieves the database type (MySQL or Mongo) that is currently active for the user.
db_connect_kaiThis 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_mysqlThis command provides a link to the MySQL database connection configuration page. The link can only be used once and expires after 5 minutes.
kai_summariesThis command retrieves the collection schema of the Mongo (Kai) database, including the collection names and corresponding field types.
kai_aggregateThis 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_summariesThis command retrieves the collection schema of the MySQL database, including the collection names and corresponding field types.
sql_queryThis command executes a MySQL query to retrieve data from the MySQL database. You need to provide the query to be executed.
notebook_createThis 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_allThis command lists all the available Jupyter Notebooks.

Configuration

User authenticationOAuth2
API documentation

For AI

Namesinglestore
DescriptionQuery your SingleStore database in English.

Updates

First added28 July 2023

Similar plugins