mcp-dbutils
If you are the rightful owner of mcp-dbutils 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 Database Utilities is a versatile MCP service that allows AI to securely access various types of databases for data analysis through a unified connection configuration.
dbutils-list-connections
Lists all available database connections in the configuration, including details like database type, host, port, and database name, while hiding sensitive information like passwords.
dbutils-list-tables
Lists all tables in a specified database connection, including table names, URIs, and available table descriptions, grouped by database type for easy identification.
dbutils-run-query
Executes read-only SQL queries (SELECT only), supporting complex queries including JOIN, GROUP BY, and aggregate functions, returning structured results with column names and data rows.
dbutils-describe-table
Provides detailed information about the table structure, including column names, data types, nullability, default values, and comments, presented in an easy-to-read format.
dbutils-get-ddl
Retrieves the complete DDL (Data Definition Language) statement for creating a specified table, including all column definitions, constraints, and indexes.