How to Use the StarRocks MCP in VS Code Copilot

Q: How does VS Code Copilot handle StarRocks queries?

By having the MCP Server configured in .vscode/mcp.json, every team member's AI assistant can call executequery against the central StarRocks cluster, providing a single source of truth for data access.

Q: Can we list all StarRocks tables in VS Code Copilot?

Yes. You can use listtables to see all available tables within a given database, and then follow up by checking the view definitions using listviews.

Standardize StarRocks operations across the team using VS Code Copilot Chat.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers — Included with Plan

Connect StarRocks MCP to VS Code Copilot

Create your Vinkius account to connect StarRocks to VS Code Copilot — we handle the hosting, security, and runtime updates so you don't have to. No server setup required.

GDPR Included with Plan

Setup StarRocks with VS Code Copilot

Ask AI about this MCP

ChatGPT

Claude

Perplexity Vinkius runs on Gemini

Gemini

Grok

Executing Standard Queries

The `execute_query` tool allows your entire engineering team to run arbitrary SQL queries against StarRocks. When configured in `.vscode/mcp.json`, every developer gets immediate access, ensuring consistency across the project. This capability standardizes how the whole team validates data assumptions using live results from the StarRocks cluster.

Standardizing Schema Checks

Use `get_table_schema` to ensure everyone is referencing the correct column names and data types when writing queries. This centralized configuration prevents schema drift issues that plague large teams. Furthermore, developers can use `list_databases` to confirm the scope of work before running any complex operations on StarRocks.

Monitoring Infrastructure Status

The team can easily check the health of the cluster using `get_cluster_info`. If a query fails, checking this tool and also using `list_nodes` quickly isolates whether the problem is application logic or infrastructure connectivity. It’s critical for maintaining operational visibility across all StarRocks deployments.

Setup guide

Set up StarRocks 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 StarRocks 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 StarRocks tools listed. Try asking: "List my recent StarRocks transactions" and Copilot will invoke them automatically.

.vscode/mcp.json

{
  "mcpServers": {
    "starrocks-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 StarRocks. 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 StarRocks 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 StarRocks MCP in VS Code Copilot

By having the MCP Server configured in `.vscode/mcp.json`, every team member's AI assistant can call `execute_query` against the central StarRocks cluster, providing a single source of truth for data access.

The team gains visibility into resource utilization through `get_storage_usage`, and can track ETL pipelines using `list_jobs` or view the lineage of data assets with `list_mvs`.

Yes. You can use `list_tables` to see all available tables within a given database, and then follow up by checking the view definitions using `list_views`.

It's perfect for team-wide adoption. It standardizes data access, meaning every developer uses the same mechanism to query and manage the core StarRocks resources.

The server handles metadata management (column names and data types) through `get_table_schema`. It ensures that all developers are working with the correct structural definitions of the StarRocks tables.

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