mcp-dbutils

Overview

mcp-dbutils provides a secure bridge between AI systems and databases, allowing models to analyze data without direct database access. It supports SQLite, MySQL, PostgreSQL and other database types through a unified configuration. The server employs a security-first architecture with read-only operations, isolated connections, and minimal data exposure. Users can browse tables, analyze schemas, and execute SQL queries while maintaining data protection and privacy.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• dbutils-list-connections

  Lists all available database connections with details while hiding sensitive information.

  Try:Show me all available database connectionsTry:List my configured databases
• dbutils-list-tables

  Lists all tables in a specified database connection with metadata.

  Try:What tables are in my database?Try:Show all tables in the postgres connection
• dbutils-run-query

  Executes read-only SQL queries and returns structured results.

  Try:Select all customers from CaliforniaTry:Find the top 10 products by sales
• dbutils-describe-table

  Provides detailed table structure including column names and data types.

  Try:What's the structure of the customers table?Try:Describe the orders table columns
• dbutils-get-ddl

  Retrieves the complete DDL statement for creating a specified table.

  Try:Show me the DDL for the products tableTry:Get the create table statement for inventory
• dbutils-list-indexes

  Lists all indexes on a specified table with their properties.

  Try:What indexes exist on the orders table?Try:Show all indexes for customers
• dbutils-get-stats

  Retrieves statistical information about a table including row count and size.

  Try:How big is the orders table?Try:Get statistics for the customers table
• dbutils-list-constraints

  Lists all constraints on a table including primary keys and foreign keys.

  Try:What constraints are on the products table?Try:Show all foreign keys in orders
• dbutils-explain-query

  Provides the execution plan for an SQL query showing how it will be processed.

  Try:Explain this query: SELECT * FROM customers WHERE age > 30Try:How will this query be executed?
• dbutils-get-performance

  Retrieves performance metrics for a database connection.

  Try:What's the performance of my database connection?Try:Show me query statistics for postgres
• dbutils-analyze-query

  Analyzes SQL query performance with execution plan and optimization suggestions.

  Try:Analyze this query for performance: SELECT SUM(amount) FROM orders GROUP BY customer_idTry:How can I optimize this query?

Comparable tools

Installation

smithery install @donghao1393/mcp-dbutils

uvx mcp-dbutils

docker run -it donghao1393/mcp-dbutils

{
  "mcpServers": {
    "dbutils": {
      "command": "mcp-dbutils",
      "args": []
    }
  }
}

FAQ

Is this server truly read-only?

Yes, mcp-dbutils only supports read operations (SELECT statements). It blocks any write operations to ensure data safety.

Can I connect to multiple databases simultaneously?

Yes, the server supports multiple database connections configured through a single YAML file.

Compare mcp-dbutils with