• EXPLORE
  • QUERY
  • MANAGE
  • REVIEW

How to run SQL queries and manage databases with your AI

Connect SingleStore to your agent to turn your chat interface into a database management console. You can navigate your entire environment without leaving your conversation.

Ask AI about this page

Short answer

Can I run SQL queries through my AI?

Yes. Your agent can list your workspaces, find specific databases, and execute SQL statements. You get direct access to your SingleStore data through natural language commands.

The outcomes

What you can do

The agent handles the heavy lifting of database navigation and execution.

EXPLORE

Map your environment

The agent identifies all available workspaces and databases. You get a clear view of your SingleStore structure immediately.

QUERY

Run SQL commands

Send any valid SQL statement to your agent. It executes the query and brings the results back to your chat.

MANAGE

Database oversight

Check your database lists and workspace settings. This keeps your environment organized without manual CLI work.

REVIEW

Human verification

The agent presents query results for you to inspect. You decide which data to keep or how to act on the findings.

The workflow

What your AI does when the request arrives.

The agent translates your intent into specific database operations.

  1. Locate workspaces

    The agent scans your SingleStore account to find where your data lives.

    list_workspaces

  2. Identify databases

    Once a workspace is found, the agent pulls a list of all databases within it.

    list_databases

  3. Execute SQL

    The agent runs your specific SQL command against the target database.

    execute_sql

  4. Return results

    The agent processes the output from the database and displays it in your chat.

    execute_sql

Try it

Copy these to start.

Use these prompts to begin interacting with your data.

Starting points

These are basic starting points. Swap out the database or table names to match your actual SingleStore setup.

SingleStore Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_CWK0SovUKcPI3nav2853E8UUtd5snsstATtMZNpM/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — SingleStore capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "singlestore-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_CWK0SovUKcPI3nav2853E8UUtd5snsstATtMZNpM/mcp"
    }
  }
}
Copy into chat04

  • List all my SingleStore workspaces.

  • Show me the databases in my production workspace.

  • Run a SQL query to select the top 10 rows from the users table.

  • Find all databases in my default workspace and tell me how many there are.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect SingleStore once, then ask.

Follow the link to authorize the connection. Your credentials stay encrypted, and you can start querying immediately.

Connect SingleStore to your AI

FAQ

How the SingleStore MCP behaves

  • 01

    Can the AI delete my databases?

    No. The available tools only allow for listing workspaces, listing databases, and executing SQL. The AI cannot perform administrative deletions through these specific tools.

  • 02

    Can I use this to create new tables?

    Yes. Since the agent can execute SQL, you can send commands to create tables or modify existing schemas.

  • 03

    Does the AI see all my data?

    The agent only sees the data returned by the SQL queries you ask it to run or the lists it pulls from your workspaces.

  • 04

    Can the AI change my SingleStore user permissions?

    No. There are no tools provided to manage user roles or permissions.

  • 05

    Do I need to write perfect SQL every time?

    You can describe what you want in plain English, and the agent will attempt to write the SQL for you, but you should always review the query before it runs.

  • More questions about SingleStore? The Connector page answers them. See everything the SingleStore Connector can do

Connect SingleStore to Claude, Cursor, ChatGPT & more