How to Use the MyScale (SQL Vector Database API) MCP in VS Code Copilot

Q: How do we share MyScale (SQL Vector Database API) configurations in VS Code Copilot?

Place the MCP configuration in .vscode/mcp.json. It's the standard way to keep your team in sync.

Q: Can we manage indices for MyScale (SQL Vector Database API) from VS Code Copilot?

You can. Use createvectorindex to push updates to your shared staging environment directly from the editor.

Standardize team database workflows in VS Code Copilot with this MyScale MCP Server.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect MyScale (SQL Vector Database API) MCP to VS Code Copilot

Create your Vinkius account to connect MyScale (SQL Vector Database API) to VS Code Copilot and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup MyScale (SQL Vector Database API) with VS Code Copilot

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Shared SQL tools for VS Code

Commit your `mcp.json` to the repo so every team member has access to `execute_sql_query`. This ensures your entire team hits the same database environment with consistent query patterns during development.

Team-wide vector search in VS Code

Use `vector_search` to verify how your application queries embeddings across different feature branches. Since the tool is configured in your repository, all developers use the same logic for similarity lookups.

Monitor cluster health in VS Code

Use `ping_cluster` to verify that your team's shared MyScale environment is responsive before running tests. It prevents the frustration of debugging code when the underlying database is actually unreachable.

Setup guide

Set up MyScale (SQL Vector Database API) MCP in VS Code Copilot

Prerequisites

VS Code 1.99 or later with GitHub Copilot extension
Active Vinkius subscription with a valid endpoint token

1

Open MCP configuration

Open the Command Palette (Cmd+Shift+P / Ctrl+Shift+P) and run "MCP: Add Server". Select HTTP (Streamable) as the server type. VS Code will create .vscode/mcp.json in your workspace.
2

Add the MyScale (SQL Vector Database API) MCP

Paste the JSON snippet shown on the right into your .vscode/mcp.json. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Switch to Agent mode

Open Copilot Chat (Cmd+Shift+I / Ctrl+Shift+I) and switch to Agent mode using the dropdown. MCP tools are only available in Agent mode — they do not appear in Edit or Ask modes.
4

Verify the connection

In the Copilot Chat input, type # to list available tools. You should see the MyScale (SQL Vector Database API) tools listed. Try asking: "List my recent MyScale (SQL Vector Database API) transactions" and Copilot will invoke them automatically.

.vscode/mcp.json

{
  "mcpServers": {
    "myscale-sql-vector-database-api-mcp": {
      "url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    }
  }
}

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by MyScale. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect MyScale (SQL Vector Database API) now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about MyScale (SQL Vector Database API) MCP in VS Code Copilot

Yes. By committing the config to your repo, everyone on the team gets the same tools for managing vector tables.

Place the MCP configuration in `.vscode/mcp.json`. It's the standard way to keep your team in sync.

You can. Use `create_vector_index` to push updates to your shared staging environment directly from the editor.

It does. When you switch to Agent mode, the tools become available for autonomous tasks across your workspace.

No. Your queries run directly from your VS Code instance to your database. No third party intercepts or logs your SQL traffic.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript

Mastra AI sdk-typescript

Start using the MyScale (SQL Vector Database API) MCP today

We host it, we monitor it, we maintain it. You just paste one token.

Get started