Xata MCP Server for VS Code CopilotGive VS Code Copilot instant access to 28 tools to Cancel Organization Invitation, Create Branch, Create Org Api Key, and more
GDPR Free for SubscribersGitHub Copilot in VS Code is the most widely adopted AI coding assistant, embedded directly into the world's most popular code editor. With MCP support in Agent mode, Copilot can access external data and APIs to generate context-aware code grounded in real-time information.
Ask AI about this MCP Server for VS Code Copilot
The Xata MCP Server for VS Code Copilot is a standout in the Databases category — giving your AI agent 28 tools to work with, ready to go from day one.
Vinkius delivers Streamable HTTP and SSE to any MCP client
Gemini{
"mcpServers": {
"xata": {
"url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
}
}
}Vinkius Desktop App
The modern way to manage MCP Servers — no config files, no terminal commands. Install Xata and 4,000+ MCP Servers from a single visual interface.
* Every MCP server runs on Vinkius-managed infrastructure inside AWS - a purpose-built runtime with per-request V8 isolates, Ed25519 signed audit chains, and sub-40ms cold starts optimized for native MCP execution. See our infrastructure
About Xata MCP Server
Connect your Xata account to any AI agent to manage your serverless data infrastructure through natural conversation.
GitHub Copilot Agent mode brings Xata data directly into your VS Code workflow. With a project-scoped config, the entire team shares access to 28 tools. Copilot queries live data, generates typed code, and writes tests from actual API responses, all without leaving the editor.
What you can do
- Organization Management — List, create, and update organizations, and manage member invitations and roles.
- Project Control — Create and list projects within your organizations and monitor resource limits and quotas.
- Database Operations — Manage branches, retrieve credentials, and execute SQL queries directly against your data.
- Developer Workflow — Handle API keys and GitHub integrations to streamline your deployment pipeline and repository mapping.
The Xata MCP Server exposes 28 tools through the Vinkius. Connect it to VS Code Copilot in under two minutes — credentials fully managed, no infrastructure to provision, no vendor lock-in. Your configuration, your data, your control.
All 28 Xata tools available for VS Code Copilot
When VS Code Copilot connects to Xata through Vinkius, your AI agent gets direct access to every tool listed below — spanning serverless, relational-database, vector-search, and more. Every call runs in a secure, isolated environment with full audit visibility. Beyond a simple connection, you get real-time monitoring of agent activity, enterprise governance, and optimized token usage.
Cancel organization invitation on Xata
Cancel a pending organization invitation
Create branch on Xata
Create a new database branch
Create org api key on Xata
Create an API key for the organization
Create organization on Xata
Create a new Xata organization
Create project on Xata
Create a new project in an organization
Create user api key on Xata
Create a new user API key
Delete user api keys on Xata
Bulk delete user API keys by ID
Execute sql on Xata
Execute single or batch SQL queries over HTTP
Get branch credentials on Xata
Retrieve database username and password for a branch
Get branch metrics on Xata
Query observability data (CPU, Memory, Disk, etc.) for a branch
Get github repository mapping on Xata
Retrieve the current GitHub repository mapping for a branch
Get organization on Xata
Get detailed information about a specific organization
Get project limits on Xata
Get resource limits for projects in an organization
Install github app on Xata
Link a GitHub App installation to an organization
Invite organization member on Xata
Invite a user to an organization via email
List branches on Xata
List all branches in a project
List images on Xata
List available PostgreSQL versions/images
List org api keys on Xata
List organization-scoped API keys
List organization invitations on Xata
List pending or expired invitations for an organization
List organization members on Xata
List members of an organization
List organizations on Xata
List all organizations the authenticated user belongs to
List projects on Xata
List all projects within an organization
List regions on Xata
List available regions for project deployment
List user api keys on Xata
List API keys for the authenticated user
Map github repository on Xata
Map a GitHub repository to a branch
Remove organization member on Xata
Remove a member from an organization
Rotate branch credentials on Xata
Trigger a password rotation for a branch
Update organization on Xata
Update organization information
Connect Xata to VS Code Copilot via MCP
Follow these steps to wire Xata into VS Code Copilot. The entire setup takes under two minutes — your credentials stay safe behind Vinkius.
Create MCP config
.vscode/mcp.json file in your project rootAdd the server config
Enable Agent mode
Start using Xata
Why Use VS Code Copilot with the Xata MCP Server
GitHub Copilot for Visual Studio Code provides unique advantages when paired with Xata through the Model Context Protocol.
VS Code is used by over 70% of developers. adding MCP tools to Copilot means your team can leverage external data without leaving their primary editor
Project-scoped MCP configs (`.vscode/mcp.json`) let you commit server configurations to your repository, ensuring the entire team shares the same tool access
Copilot's Agent mode integrates MCP tools seamlessly with file editing, terminal commands, and workspace search in a single agentic loop
GitHub's enterprise compliance and audit features extend to MCP tool usage, providing visibility into how AI interacts with external services
Xata + VS Code Copilot Use Cases
Practical scenarios where VS Code Copilot combined with the Xata MCP Server delivers measurable value.
Live API integration: Copilot can query an MCP server, inspect the response schema, and generate typed API client code in the same step
DevSecOps workflows: security teams can give developers access to domain intelligence tools directly in their editor for real-time vulnerability assessment during code review
Data pipeline development: Copilot fetches sample data via MCP and generates transformation scripts, validators, and test fixtures from actual API responses
Documentation generation: Copilot queries available tools and auto-generates README sections, API reference docs, and usage examples
Example Prompts for Xata in VS Code Copilot
Ready-to-use prompts you can give your VS Code Copilot agent to start working with Xata immediately.
"List all my Xata organizations."
"Invite dev@example.com to organization org-123."
"Show me the projects in organization 'org-123'."
Troubleshooting Xata MCP Server with VS Code Copilot
Common issues when connecting Xata to VS Code Copilot through Vinkius, and how to resolve them.
MCP tools not available
Xata + VS Code Copilot FAQ
Common questions about integrating Xata MCP Server with VS Code Copilot.
Which VS Code version supports MCP?
How do I switch to Agent mode?
Can I restrict which MCP tools Copilot can access?
Does MCP work in VS Code Remote or Codespaces?
.vscode/mcp.json work in Remote SSH, WSL, and GitHub Codespaces environments. The MCP connection is established from the remote host, so ensure the server URL is accessible from that environment.Explore More MCP Servers
View all →
TripGo
9 toolsAI multimodal transit: plan trips, track vehicles, and check schedules via agents.
Jestor
10 toolsManage data, workflows, and records via Jestor low-code API.
Daftra
10 toolsEquip your AI agent to manage your ERP, accounting, and client relations directly via the Daftra API.
HigherGov
12 toolsFind and track government contracts, grants, and procurement opportunities with intelligence built for public sector vendors.