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
1
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.
2
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)
3
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.
4
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
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