mcp-dbutils

mcp-dbutils

3.9

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@mcpreview.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.