# MCP Toolbox for Databases

> MCP Toolbox for Databases is an open source MCP server for databases. It enables you to develop tools easier, faster, and more securely by handling the complexities such as connection pooling, authentication, and more.

## Docs

### Getting Started

How to get started with Toolbox.
- [Introduction](https://googleapis.github.io/genai-toolbox/previews/PR-1305/getting-started/introduction/): An introduction to MCP Toolbox for Databases.
- [Python Quickstart (Local)](https://googleapis.github.io/genai-toolbox/previews/PR-1305/getting-started/local_quickstart/): How to get started running Toolbox locally with [Python](https://github.com/googleapis/mcp-toolbox-sdk-python), PostgreSQL, and  [Agent Development Kit](https://google.github.io/adk-docs/), [LangGraph](https://www.langchain.com/langgraph), [LlamaIndex](https://www.llamaindex.ai/) or [GoogleGenAI](https://pypi.org/project/google-genai/).
- [JS Quickstart (Local)](https://googleapis.github.io/genai-toolbox/previews/PR-1305/getting-started/local_quickstart_js/): How to get started running Toolbox locally with [JavaScript](https://github.com/googleapis/mcp-toolbox-sdk-js), PostgreSQL, and orchestration frameworks such as [LangChain](https://js.langchain.com/docs/introduction/), [GenkitJS](https://genkit.dev/docs/get-started/),  [LlamaIndex](https://ts.llamaindex.ai/) and [GoogleGenAI](https://github.com/googleapis/js-genai).
- [Go Quickstart (Local)](https://googleapis.github.io/genai-toolbox/previews/PR-1305/getting-started/local_quickstart_go/): How to get started running Toolbox locally with [Go](https://github.com/googleapis/mcp-toolbox-sdk-go), PostgreSQL, and orchestration frameworks such as [LangChain Go](https://tmc.github.io/langchaingo/docs/), [GenkitGo](https://genkit.dev/go/docs/get-started-go/), [Go GenAI](https://github.com/googleapis/go-genai) and [OpenAI Go](https://github.com/openai/openai-go).
- [Quickstart (MCP)](https://googleapis.github.io/genai-toolbox/previews/PR-1305/getting-started/mcp_quickstart/): How to get started running Toolbox locally with MCP Inspector.
- [Configuration](https://googleapis.github.io/genai-toolbox/previews/PR-1305/getting-started/configure/): How to configure Toolbox's tools.yaml file.

### Concepts

Some core concepts in Toolbox
- [Telemetry](https://googleapis.github.io/genai-toolbox/previews/PR-1305/concepts/telemetry/): An overview of telemetry and observability in Toolbox.

### How-to

List of guides detailing how to do different things with Toolbox. 
- [Connect from your IDE](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/connect-ide/): List of guides detailing how to connect your AI tools (IDEs) to Toolbox using MCP.
  - [AlloyDB Admin API using MCP](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/connect-ide/alloydb_pg_admin_mcp/): Create your AlloyDB database with MCP Toolbox.
  - [AlloyDB using MCP](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/connect-ide/alloydb_pg_mcp/): Connect your IDE to AlloyDB using Toolbox.
  - [BigQuery using MCP](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/connect-ide/bigquery_mcp/): Connect your IDE to BigQuery using Toolbox.
  - [Cloud SQL for MySQL using MCP](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/connect-ide/cloud_sql_mysql_mcp/): Connect your IDE to Cloud SQL for MySQL using Toolbox.
  - [Cloud SQL for Postgres using MCP](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/connect-ide/cloud_sql_pg_mcp/): Connect your IDE to Cloud SQL for Postgres using Toolbox.
  - [Cloud SQL for SQL Server using MCP](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/connect-ide/cloud_sql_mssql_mcp/): Connect your IDE to Cloud SQL for SQL Server using Toolbox.
  - [Firestore using MCP](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/connect-ide/firestore_mcp/): Connect your IDE to Firestore using Toolbox.
  - [Looker using MCP](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/connect-ide/looker_mcp/): Connect your IDE to Looker using Toolbox.
  - [MySQL using MCP](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/connect-ide/mysql_mcp/): Connect your IDE to MySQL using Toolbox.  - [PostgreSQL using MCP](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/connect-ide/postgres_mcp/): Connect your IDE to PostgreSQL using Toolbox.
  - [Spanner using MCP](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/connect-ide/spanner_mcp/): Connect your IDE to Spanner using Toolbox.
  - [SQL Server using MCP](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/connect-ide/mssql_mcp/): Connect your IDE to SQL Server using Toolbox.- [Connect via MCP Client](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/connect_via_mcp/): How to connect to Toolbox from a MCP Client.
- [Toolbox UI](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/toolbox-ui/): How to effectively use Toolbox UI.
- [Deploy to Cloud Run](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/deploy_toolbox/): How to set up and configure Toolbox to run on Cloud Run.
- [Deploy to Kubernetes](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/deploy_gke/): How to set up and configure Toolbox to deploy on Kubernetes with Google Kubernetes Engine (GKE).
- [Deploy using Docker Compose](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/deploy_docker/): How to deploy Toolbox using Docker Compose.
- [Export Telemetry](https://googleapis.github.io/genai-toolbox/previews/PR-1305/how-to/export_telemetry/): How to set up and configure Toolbox to use the Otel Collector.

### Resources

List of reference documentation for resources in Toolbox.
- [AuthServices](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/authservices/): AuthServices represent services that handle authentication and authorization.
  - [Google Sign-In](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/authservices/google/): Use Google Sign-In for Oauth 2.0 flow and token lifecycle.
- [Sources](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/): Sources represent your different data sources that a tool can interact with.
  - [AlloyDB for PostgreSQL](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/alloydb-pg/): AlloyDB for PostgreSQL is a fully-managed, PostgreSQL-compatible database for  demanding transactional workloads.
  - [BigQuery](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/bigquery/): BigQuery is Google Cloud's fully managed, petabyte-scale, and cost-effective analytics data warehouse that lets you run analytics over vast amounts of  data in near real time. With BigQuery, there's no infrastructure to set  up or manage, letting you focus on finding meaningful insights using  GoogleSQL and taking advantage of flexible pricing models across on-demand  and flat-rate options.
  - [Bigtable](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/bigtable/): Bigtable is a low-latency NoSQL database service for machine learning, operational analytics, and user-facing operations. It's a wide-column, key-value store that can scale to billions of rows and thousands of columns. With Bigtable, you can replicate your data to regions across the world for high availability and data resiliency.
  - [ClickHouse](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/clickhouse/): ClickHouse is an open-source, OLTP database.
  - [Cloud SQL for MySQL](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/cloud-sql-mysql/): Cloud SQL for MySQL is a fully-managed database service for MySQL.
  - [Cloud SQL for PostgreSQL](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/cloud-sql-pg/): Cloud SQL for PostgreSQL is a fully-managed database service for Postgres.
  - [Cloud SQL for SQL Server](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/cloud-sql-mssql/): Cloud SQL for SQL Server is a fully-managed database service for SQL Server.
  - [couchbase](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/couchbase/): A "couchbase" source connects to a Couchbase database.
  - [Dataplex](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/dataplex/): Dataplex Universal Catalog is a unified, intelligent governance solution for data and AI assets in Google Cloud. Dataplex Universal Catalog powers AI, analytics, and business intelligence at scale.
  - [Dgraph](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/dgraph/): Dgraph is fully open-source, built-for-scale graph database for Gen AI workloads
  - [Firebird](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/firebird/): Firebird is a powerful, cross-platform, and open-source relational database.
  - [Firestore](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/firestore/): Firestore is a NoSQL document database built for automatic scaling, high performance, and ease of application development. It's a fully managed, serverless database that supports mobile, web, and server development.
  - [HTTP](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/http/): The HTTP source enables the Toolbox to retrieve data from a remote server using HTTP requests.
  - [Looker](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/looker/): Looker is a business intelligence tool that also provides a semantic layer.
  - [MongoDB](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/mongodb/): MongoDB is a no-sql data platform that can not only serve general purpose data requirements also perform VectorSearch where both operational data and embeddings used of search can reside in same document.
  - [MySQL](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/mysql/): MySQL is a relational database management system that stores and manages data.
  - [Neo4j](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/neo4j/): Neo4j is a powerful, open source graph database system
  - [OceanBase](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/oceanbase/): OceanBase is a distributed relational database that provides high availability, scalability, and compatibility with MySQL.
  - [PostgreSQL](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/postgres/): PostgreSQL is a powerful, open source object-relational database.
  - [Redis](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/redis/): Redis is a in-memory data structure store.
  - [Spanner](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/spanner/): Spanner is a fully managed database service from Google Cloud that combines  relational, key-value, graph, and search capabilities.
  - [SQL Server](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/mssql/): SQL Server is a relational database management system (RDBMS).
  - [SQLite](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/sqlite/): SQLite is a C-language library that implements a small, fast, self-contained,  high-reliability, full-featured, SQL database engine.
  - [TiDB](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/tidb/): TiDB is a distributed SQL database that combines the best of traditional RDBMS and NoSQL databases.
  - [Trino](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/trino/): Trino is a distributed SQL query engine for big data analytics.
  - [Valkey](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/sources/valkey/): Valkey is an open-source, in-memory data structure store, forked from Redis.
- [Tools](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/): Tools define actions an agent can take -- such as reading and writing to a source.
  - [AlloyDB AI NL](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/alloydbainl/): AlloyDB AI NL Tool.
  - [BigQuery](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/bigquery/): Tools that work with BigQuery Sources.
  - [Bigtable](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/bigtable/): Tools that work with Bigtable Sources.
  - [ClickHouse](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/clickhouse/): Tools for interacting with ClickHouse databases and tables.
  - [Couchbase](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/couchbase/): Tools that work with Couchbase Sources.
  - [Dataplex](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/dataplex/): Tools that work with Dataplex Sources.
  - [Dgraph](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/dgraph/): Tools that work with Dgraph Sources.
  - [Firebird](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/firebird/): Tools that work with Firebird Sources.
  - [Firestore](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/firestore/): Tools that work with Firestore Sources.
  - [HTTP](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/http/): Tools that work with HTTP Sources.
  - [Looker](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/looker/): Tools that work with Looker Sources.
  - [MongoDB](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/mongodb/): Tools that work with the MongoDB Source.
  - [MySQL](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/mysql/): Tools that work with MySQL Sources, such as Cloud SQL for MySQL.
  - [Neo4j](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/neo4j/): Tools that work with Neo4j Sources.
  - [OceanBase](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/oceanbase/): Tools that work with OceanBase Sources.
  - [Postgres](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/postgres/): Tools that work with Postgres Sources, such as Cloud SQL for Postgres and AlloyDB. 
  - [Redis](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/redis/): Tools that work with Redis Sources.
  - [Spanner](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/spanner/): Tools that work with Spanner Sources.
  - [SQL Server](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/mssql/): Tools that work with SQL Server Sources, such as CloudSQL for SQL Server.
  - [SQLite](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/sqlite/): Tools that work with SQLite Sources.
  - [TiDB](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/tidb/): Tools that work with TiDB Sources, such as TiDB Cloud and self-hosted TiDB.
  - [Trino](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/trino/): Tools that work with Trino Sources, such as distributed SQL query engine.
  - [Utility tools](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/utility/): Tools that provide utility.
  - [Valkey](https://googleapis.github.io/genai-toolbox/previews/PR-1305/resources/tools/valkey/): Tools that work with Valkey Sources.

### Samples

Samples and guides for using Toolbox.
- [AlloyDB](https://googleapis.github.io/genai-toolbox/previews/PR-1305/samples/alloydb/): How to get started with Toolbox using AlloyDB.
  - [Quickstart (MCP with AlloyDB)](https://googleapis.github.io/genai-toolbox/previews/PR-1305/samples/alloydb/mcp_quickstart/): How to get started running Toolbox with MCP Inspector and AlloyDB as the source.
  - [Getting started with alloydb-ai-nl tool](https://googleapis.github.io/genai-toolbox/previews/PR-1305/samples/alloydb/ai-nl/): An end to end tutorial for building an ADK agent using the AlloyDB AI NL tool.
- [BigQuery](https://googleapis.github.io/genai-toolbox/previews/PR-1305/samples/bigquery/): How to get started with Toolbox using BigQuery.
  - [Quickstart (Local with BigQuery)](https://googleapis.github.io/genai-toolbox/previews/PR-1305/samples/bigquery/local_quickstart/): How to get started running Toolbox locally with Python, BigQuery, and LangGraph, LlamaIndex, or ADK.
  - [Quickstart (MCP with BigQuery)](https://googleapis.github.io/genai-toolbox/previews/PR-1305/samples/bigquery/mcp_quickstart/): How to get started running Toolbox with MCP Inspector and BigQuery as the source.
- [Looker](https://googleapis.github.io/genai-toolbox/previews/PR-1305/samples/looker/): How to get started with Toolbox using Looker.
  - [Gemini-CLI and OAuth](https://googleapis.github.io/genai-toolbox/previews/PR-1305/samples/looker/looker_gemini_oauth/): How to connect to Looker from Gemini-CLI with end-user credentials
  - [Quickstart (MCP with Looker and Gemini-CLI)](https://googleapis.github.io/genai-toolbox/previews/PR-1305/samples/looker/looker_gemini/): How to get started running Toolbox with Gemini-CLI and Looker as the source.
  - [Quickstart (MCP with Looker)](https://googleapis.github.io/genai-toolbox/previews/PR-1305/samples/looker/looker_mcp_inspector/): How to get started running Toolbox with MCP Inspector and Looker as the source.

### About

A list of other information related to Toolbox.
- [FAQ](https://googleapis.github.io/genai-toolbox/previews/PR-1305/about/faq/): Frequently asked questions about Toolbox.
### SDKs

Client SDKs to connect to the MCP Toolbox server.
- [Go SDK](https://googleapis.github.io/genai-toolbox/previews/PR-1305/sdks/go-sdk/): Go lang client SDK- [JS SDK](https://googleapis.github.io/genai-toolbox/previews/PR-1305/sdks/js-sdk/): Javascript client SDK- [Python SDK](https://googleapis.github.io/genai-toolbox/previews/PR-1305/sdks/python-sdk/): Python client SDK
### Reference

This section contains reference documentation.
- [CLI](https://googleapis.github.io/genai-toolbox/previews/PR-1305/reference/cli/): This page describes the `toolbox` command-line options.
- [Prebuilt Tools](https://googleapis.github.io/genai-toolbox/previews/PR-1305/reference/prebuilt-tools/): This page lists all the prebuilt tools available.