mcp-server-spanner
If you are the rightful owner of mcp-server-spanner and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
MCP Server for Spanner is a Model Context Protocol server designed to connect to Google Cloud Spanner databases and execute SQL queries, primarily serving as a tool for AI assistants to interact with Spanner databases.
MCP Server for Spanner is a specialized server that facilitates the execution of SQL queries on Google Cloud Spanner databases. It is particularly useful for AI assistants and other applications that require interaction with Spanner databases. The server supports a range of SQL operations, including SELECT, INSERT, UPDATE, DELETE, and DDL commands. It also provides functionalities to retrieve and display table structures. The server is designed to work with the Spanner emulator, making it suitable for development and testing environments. Installation requires Node.js 22 or higher, and the server can be set up using a devcontainer for streamlined development. The server can be integrated with platforms like Claude Desktop and used with tools like MCP Inspector for development purposes.
Features
- Execution of SELECT queries
- Execution of data modification queries (INSERT, UPDATE, DELETE)
- Execution of DDL queries (CREATE TABLE, ALTER TABLE, etc.)
- Retrieval of table lists
- Detailed display of table structures
Tools
read_query
Perform a SELECT query
list_tables
Get a list of tables in the database
describe_table
Displays the structure of the specified table
execute_ddl
Perform DDL query
execute_write
Perform an update operation (INSERT, UPDATE, DELETE)
