• SEARCH
  • QUERY
  • INSIGHT
  • HUMAN

How to query and manage vector data with your AI

Connect MyScale to your AI client once. From there, you can use natural language to find similar vectors or run standard SQL queries.

Ask AI about this page

Short answer

How can I query and manage vector data with my AI?

Your agent uses specific tools to run SQL commands and similarity searches on your MyScale cluster. You get direct access to your database through your chat interface. This breakdown shows what you can do.

Data outcomes

Where your data goes

The different ways your AI handles your requests.

SEARCH

Find similar vectors

The AI finds data points closest to your query in the vector space. You get the most relevant matches immediately.

QUERY

Run SQL commands

Your agent translates your questions into SQL. It pulls specific rows and columns from your MyScale tables.

INSIGHT

Analyze results

The AI processes the data returned from your cluster. You get clear answers instead of raw database dumps.

HUMAN

Verify the data

You review the SQL logic or the returned records. You decide if the data is correct before moving forward.

The workflow

What your AI does when the request arrives.

The AI acts as the bridge between your chat and the MyScale cluster.

  1. Identify intent

    Your agent determines if you need a similarity search or a standard SQL query based on your question.

    vector_searchexecute_sql_query

  2. Perform search

    The AI locates the closest vector matches in your database.

    vector_search

  3. Execute SQL

    The agent sends the necessary commands to your MyScale cluster to fetch specific records.

    execute_sql_query

  4. Deliver data

    The AI takes the raw results and presents them in your chat window.

    execute_sql_queryvector_search

Try it

Copy these to start.

Use these prompts to start interacting with your MyScale data.

Starting points

Swap the bracketed text for your actual table names or search terms.

MyScale Connector

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

Connector linkhttps://edge.vinkius.com/vk_preview_vWeauVyztoYzGBsy6h9azMYGgJ3R8tQDDZfTvuoy/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 — MyScale capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "myscale-sql-vector-database-api-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_vWeauVyztoYzGBsy6h9azMYGgJ3R8tQDDZfTvuoy/mcp"
    }
  }
}
Copy into chat04

  • Find the top 5 most similar vectors to [insert vector/text] in the [table_name] table.

  • Run a SQL query to show me all rows in [table_name] where [column] is greater than 100.

  • Search for items in my vector database that are similar to [description of item].

  • Show me the schema for the [table_name] table so I know what I can query.

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

Start here

Connect MyScale once, then ask.

One link connects the MCP to your client. Your login stays encrypted on our side, and you can start querying immediately.

Connect MyScale to your AI

FAQ

How the MyScale task behaves

  • 01

    Can my AI delete data from MyScale?

    No. The tools only allow for searching and executing queries. The AI cannot perform destructive operations like dropping tables or deleting rows.

  • 02

    Can the AI create new tables?

    No. The tools are limited to executing queries and performing vector searches. You must manage your database schema manually.

  • 03

    Does the AI write the SQL itself?

    Yes. Your agent translates your natural language requests into SQL commands that the MyScale cluster understands.

  • 04

    Can I use this with any AI client?

    Yes, as long as the client supports the Model Context Protocol (MCP).

  • 05

    Will the AI show me the raw data?

    Yes. The AI retrieves the data from MyScale and presents it to you in the chat interface.

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

Connect MyScale to Claude, Cursor, ChatGPT & more