Connect Spanner to VS Code
Enable VS Code to access your Spanner data through secure, governed MCP servers—no manual queries or engineering bottlenecks
How it works
1. Connect your database
Provide your Spanner connection details. We'll securely connect to your data source.
2. Define your MCP tools
Configure the tools and data available to your AI agents.
3. Deploy your MCP server
We convert your config into a production-ready MCP server with enterprise governance.
How to connect
Connect your Spanner database
- •GCP project and instance: Google Cloud project ID and Spanner instance identifier
- •Database name: Target Spanner database within the instance
- •SQL dialect: GoogleSQL (ANSI 2011 with extensions) or PostgreSQL dialect
- •Configure data access: Define which tables and queries are available to AI agents
- •Automatic deployment: We deploy your MCP server with enterprise governance—no manual setup required
Link your PostgreSQL MCP to VS Code
- 1.Open VS Code and run the MCP: Add Server command
- 2.Select 'Global' to configure across all workspaces
- 3.Add your MintMCP Gateway server URL (HTTP/SSE transport)
- 4.Configure authentication headers with your credentials
- 5.Access PostgreSQL data through GitHub Copilot Chat
Other supported AI clients
One-time setup connects Spanner to all your AI tools
What you get
Faster deployment
Define your Spanner connection once, then add more MCP tools as needed through simple config updates. No code required.
Rapid iteration
Build team or use-case specific tools rapidly by adding new queries and parameters to your config. Deploy updates in minutes, not days.
Enterprise governance
All database access goes through MintMCP Gateway with full observability, authentication, rate limiting, and audit trails.
Why MintMCP gateway
Centralized governance
Unified authentication, audit logging, and rate control for all database MCP connections.
One-click deployment
Instantly enable database MCP for AI teams via MintMCP's standardized gateway without manual server setup.
OAuth + SSO enforcement
Automatic enterprise authentication wrapping for database MCP endpoints.
Host stdio servers on MintMCP instead of running locally
Containerized servers become accessible to clients like ChatGPT without local installations. Better risk management and security posture without requiring users to run servers on their machines.
Observability and control
Real-time dashboards for monitoring usage, detecting anomalies, and maintaining SLA compliance.
Enterprise hardening
High availability, security, and compliance alignment transform MCP from developer utility to production-grade infrastructure.
Supports shared and per-user auth
Flexibility to configure service accounts at the admin level or enable individual OAuth flows. Secrets remain protected while users gain access, with centralized revocation capabilities.
Granular tool access control
Configure tool access by role. For example, enable read-only operations and exclude write tools like create and delete.
Use cases
Global financial transaction analysis
Enable analysts to investigate banking transactions, payment flows, and trading activity across multiple regions through natural language—AI agents query globally distributed Spanner data without understanding ACID semantics or multi-region architecture.
Multi-region e-commerce analytics
Let operations teams analyze product inventory, order patterns, and customer behavior across global regions by asking questions in natural language—AI agents access strongly consistent data without manual SQL or region coordination.
AdTech campaign and bidding analysis
Enable marketing teams to investigate ad campaigns, bidding patterns, and performance metrics through conversational queries—AI agents query globally distributed programmatic advertising data without low-latency query optimization.
Other supported databases
Connect to 30+ other database types including SQL, NoSQL, and cloud-native databases
FAQs
Yes. MintMCP Gateway is SOC 2 compliant and uses OAuth-based authentication for all database MCP interactions.
Ready to connect Spanner to VS Code?
Join enterprises that trust MintMCP Gateway to manage their database AI integrations securely and efficiently.