How to Use the Xata (Serverless DB) MCP in VS Code Copilot

Q: How do I run queries against Xata (Serverless DB) with VS Code Copilot?

The agent uses the executesql tool. It takes your query and runs it against a specific branch, providing reliable results that can be used for coding tasks.

Q: Can I track project scope using Xata (Serverless DB) with VS Code Copilot?

Yes. You use listprojects to see all active projects in the organization. This helps prevent developers from accidentally working outside the intended scope.

Q: If I need credentials details for Xata (Serverless DB) in VS Code Copilot, how do I get them?

Use the getbranchcredentials tool. This allows your agent to retrieve and securely handle necessary branch keys without manual intervention.

Q: Is managing organization membership covered by Xata (Serverless DB) with VS Code Copilot?

Absolutely. The MCP Server provides tools like listmembers and removemember. This lets your team manage access control directly through the shared config.

Standardize database access and manage Xata (Serverless DB) with VS Code Copilot.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Xata (Serverless DB) MCP to VS Code Copilot

Create your Vinkius account to connect Xata (Serverless DB) 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 Xata (Serverless DB) with VS Code Copilot

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Project Scoping via MCP Server

For team consistency, use the MCP Server to define project boundaries. Committing the configuration allows every developer to access shared tools like `list_projects` and `get_project`. This keeps everyone on the same page regarding data scope. New initiatives? Just call `create_project`, and the entire team immediately has that context available.

Bulk Data Operations in VS Code Copilot

When you need to make changes across multiple tables, use `execute_sql_batch`. This runs a list of SQL queries as one transaction, which is exactly what you want for reliable team development. Alternatively, the simple `list_branches` lets developers quickly see all available data containers.

Organizational Setup and Governance

Governance starts with organization access. The MCP Server lets teams use tools like `list_members` to audit who has access, or call `remove_member` if someone's role changes. You can also request deletion of an entire org using `request_organization_deletion` when a client relationship ends.

Setup guide

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

.vscode/mcp.json

{
  "mcpServers": {
    "xata-serverless-db-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 Xata. 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 Xata (Serverless DB) 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 Xata (Serverless DB) MCP in VS Code Copilot

The agent uses the `execute_sql` tool. It takes your query and runs it against a specific branch, providing reliable results that can be used for coding tasks.

Yes. You use `list_projects` to see all active projects in the organization. This helps prevent developers from accidentally working outside the intended scope.

It manages Organization IDs, Project Names, Branch Credentials, and Member UUIDs. This covers most of what a development team needs to track.

Use the `get_branch_credentials` tool. This allows your agent to retrieve and securely handle necessary branch keys without manual intervention.

Absolutely. The MCP Server provides tools like `list_members` and `remove_member`. This lets your team manage access control directly through the shared config.

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