SmartDB_MCP

Overview

SmartDB is a comprehensive MCP server that provides universal database connectivity across multiple major database systems including MySQL, PostgreSQL, SQL Server, MariaDB, DM8, and Oracle. What sets it apart from other database tools is its integration of advanced features like OAuth 2.0 authentication, comprehensive health checks, SQL optimization suggestions, and index health monitoring. The server supports multiple connection modes including stdio, sse, and streamableHttp, making it flexible for different integration scenarios. The toolset includes SQL execution, database health analysis, table structure exploration, index management, SQL generation, and optimization features.

Try asking AI

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

• execute_sql

  Execute SQL commands (SELECT, SHOW, DESCRIBE, EXPLAIN, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, TRUNCATE)

  Try:Show all tables in the databaseTry:Get the top 10 customers by revenueTry:Create a new user table
• get_db_health

  Analyze database health status and provide diagnostic reports

  Try:Check the health of the databaseTry:Detect any locks in the databaseTry:Get database connection status
• get_table_desc

  Search for table structures in the database

  Try:Get the structure of the customers tableTry:Describe the orders table columnsTry:Show schema for the products table
• get_table_index

  Search for table indexes in the database

  Try:Show indexes on the users tableTry:Get all indexes for the orders tableTry:List indexes for the inventory table
• get_table_name

  Query all table names in the database or search by name/description

  Try:List all tables in the databaseTry:Find tables related to customer informationTry:Search for tables with 'order' in the name
• get_db_version

  Query database version information

  Try:What version of MySQL is running?Try:Get the PostgreSQL versionTry:Check the Oracle database version
• sql_creator

  Generate SQL queries based on different database types

  Try:Create a SQL query to get monthly salesTry:Generate a SELECT statement for customer dataTry:Write a query to find all products out of stock
• sql_optimize

  Optimize SQL performance with expert suggestions

  Try:Optimize this query: SELECT * FROM customers WHERE date > '2023-01-01'Try:Improve the performance of the sales reportTry:How can I make this query faster?

Comparable tools

Installation

pip install SmartDB-MCP
smartdb --envfile=/path/to/.env --oauth=true

docker-compose up -d

uv sync
uv run -m core.server --mode stdio

{
  "mcpServers": {
    "smartdb": {
      "name": "smartdb",
      "type": "stdio",
      "command": "uv",
      "args": [
        "--directory",
        "/path/to/SmartDB/",
        "run",
        "-m",
        "core.server",
        "--mode",
        "stdio"
      ],
      "env": {
        "DATABASE_CONFIG_FILE": "/path/to/database_config.json"
      }
    }
  }
}

FAQ

Which databases are supported by SmartDB?

SmartDB supports MySQL, PostgreSQL, SQL Server, MariaDB, DM8, and Oracle databases.

Does SmartDB support OAuth authentication?

Yes, SmartDB supports OAuth 2.0 authentication for secure database access, particularly when using streamableHttp mode.

What are the different connection modes supported?

SmartDB supports three connection modes: stdio, sse (Server-Sent Events), and streamableHttp for flexible integration with different clients.

Compare SmartDB_MCP with