Quick Install
Prerequisites
- VS Code with GitHub Copilot extension installed
- MCP support enabled in VS Code (available in VS Code 1.99+)
- A VexiData account with at least one connected database
Manual Setup
Copy your MCP Server URL
Your MCP Server URL is:You can also find this in Settings > AI Integrations in your VexiData AI Integrations page.
Add VexiData as an MCP server
- Open VS Code
- Open the Command Palette (
Ctrl+Shift+P/Cmd+Shift+P) - Search for MCP: Add Server
- Select HTTP (SSE) as the transport type
- Paste your MCP Server URL
- Enter a name (e.g., “VexiData”)
- Choose whether to save it to User Settings (global) or Workspace Settings (project-only)
Authorize the connection
VS Code will open a browser window to VexiData for authorization. Review the requested permissions and click Approve.Once authorized, you’ll see VexiData listed in your MCP servers.
Start querying your data
In Copilot Chat, you can now reference your database. For example:
- “What columns does the users table have?”
- “Write a query to get the top 10 customers by total spend”
- “Generate a migration to add an
is_activecolumn to the orders table”
Manual configuration file
You can also add VexiData directly to your VS Code settings (.vscode/mcp.json in your project or user settings):
Troubleshooting
MCP option not available
MCP option not available
- MCP support requires VS Code 1.99 or later
- Make sure the GitHub Copilot extension is installed and active
- Check that MCP is not disabled in your VS Code settings
MCP server shows as disconnected
MCP server shows as disconnected
- Check that your VexiData account has an active session — try logging in at vexidata.com
- Verify the MCP Server URL is correct in your settings
- Try removing and re-adding the MCP server via the Command Palette
Authorization window doesn't open
Authorization window doesn't open
Copilot can't access my tables
Copilot can't access my tables
- Verify you have at least one database connected in VexiData under Data Sources
- Check that your database connection is active and the schema has been analyzed
- Try asking specifically about a table name to confirm the connection is working