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.

MCP Database Utilities serves as a secure bridge between AI systems and databases, enabling AI to read and analyze data without direct database access or risk of data modification. It supports multiple databases like SQLite, MySQL, and PostgreSQL through a single interface, ensuring data privacy and security. The tool is designed with a security-first architecture, making it ideal for enterprises, startups, and individual users who prioritize data protection. It offers features like strict read-only operations, isolated connections, and automatic timeouts to enhance security. The configuration is simplified using a single YAML file for all database connections, and it provides advanced functionalities such as table browsing, schema analysis, and query execution.

Features

  • Security-first: Strictly read-only operations, no direct database access, isolated connections, on-demand connections, automatic timeouts.
  • Privacy assurance: Local processing, minimal data exposure, credential protection, sensitive data masking.
  • Multi-database support: Connects to SQLite, MySQL, PostgreSQL using the same interface.
  • Simple configuration: All database connections use a single YAML file.
  • Advanced features: Table browsing, schema analysis, and query execution.

Tools

  • 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.