GenAI Toolbox

Overview

GenAI Toolbox is Google’s answer to “how do I let my AI agent safely query my database?” It’s an MCP server connecting agents to PostgreSQL, MySQL, SQLite, Spanner, AlloyDB, and BigQuery — with enterprise security including query validation, parameterized queries, and connection pooling.

How It Works

1. Configure data sources — Define database connections in YAML
2. Set up tools — Define allowed queries and operations
3. Deploy — Run locally or on Cloud Run
4. Connect agents — Any MCP client queries databases safely

Use Cases

• Business intelligence — Ask questions about data in plain English
• Data exploration — AI-assisted SQL generation and execution
• Reporting — Automated report generation from database queries
• Analytics — Natural language interface to analytics databases

Getting Started

sources:
  my-postgres:
    kind: postgres
    host: localhost
    port: 5432
    database: myapp
tools:
  search-users:
    kind: postgres-sql
    source: my-postgres
    sql: "SELECT id, name FROM users WHERE name ILIKE $1"

Example

User: "How many users signed up last month?"
Agent → GenAI Toolbox → SQL → Returns: {new_users: 1247}
Agent: "1,247 new users signed up last month."

Alternatives

• MCP PostgreSQL Server — Simpler, single-database MCP server
• Composio — Database access via managed integrations
• LangChain SQL Agent — LangChain-specific database querying