Skip to main content
AllMCPs
BrowseBestCategoriesStackCompareToolsGuidesBlog
Log in Submit MCP

Stay in the loop

Get new MCP servers and top picks in your inbox.

AllMCPs

The open directory for discovering and installing Model Context Protocol servers.

AllMCPs on GitHub (opens in a new tab)
Launched onTiny Startupstinystartups.com
Explore
  • Browse servers
  • Best MCP servers
  • Categories
  • MCP clients
  • Agent prompts
  • Stack Builder
  • Compare servers
  • Random discovery New
  • Submit a server
  • Pricing & Boost Boost
Learn
  • Guides hub
  • What is MCP?
  • Install guide
  • Build an MCP server
  • Deploy an MCP server
  • Security guide
  • Troubleshooting
  • MCP for SEO & AEO
  • Protocol versioning
  • Blog & updates
Tools
  • All developer tools
  • Config generator
  • Config validator
  • Config auditor
  • MCP playground
  • Token calculator
  • OpenAPI → MCP
  • Badge generator
For agents
  • REST API docs
  • Trust & traffic Live
  • Remote MCP server SSE ↗ (opens in a new tab)
  • llms.txt ↗ (opens in a new tab)
  • Catalog JSON ↗ (opens in a new tab)
Company
  • About
  • Advertise Sponsor
  • Contact
  • GitHub ↗ (opens in a new tab)
  • Terms
  • Privacy
AllMCPs VerifiedAllMCPs VerifiedFeatured on Nick LaunchesFeatured on Nick LaunchesLaunch Llama NewsletterLaunch Llama NewsletterVerified DR - allmcps.comVerified DR - allmcps.comFeatured on SaaSGrowFeatured on SaaSGrowFeatured on Twelve ToolsFeatured on Twelve ToolsFeatured on Saaspa.geFeatured on Saaspa.geFeatured on Findly.toolsFeatured on Findly.toolsFeatured on Startup FameFeatured on Startup FameFeatured on LaunchKiwiFeatured on LaunchKiwiFeatured on ScrollLaunchFeatured on ScrollLaunchFeatured on DailyPingsFeatured on DailyPingsFazier badgeFazier badgeFeatured on NewTool.siteFeatured on NewTool.siteFeatured on saasfame.comFeatured on saasfame.comDR Checker - Domain RatingDR Checker - Domain RatingListed on Turbo0Listed on Turbo0Launched on LaunchBoard - Product Launch PlatformLaunched on LaunchBoard - Product Launch PlatformList on SimilarlabsList on Similarlabshttps://codetrendy.comhttps://codetrendy.comListed on DevTool.ioFeatured on BuildlistFeatured on BuildlistLaunched on Tiny StartupsFeatured on ShowMeBestAIFeatured on ShowMeBestAIFind us on LaunchZoneFind us on LaunchZoneAllMCPs VerifiedAllMCPs VerifiedFeatured on Nick LaunchesFeatured on Nick LaunchesLaunch Llama NewsletterLaunch Llama NewsletterVerified DR - allmcps.comVerified DR - allmcps.comFeatured on SaaSGrowFeatured on SaaSGrowFeatured on Twelve ToolsFeatured on Twelve ToolsFeatured on Saaspa.geFeatured on Saaspa.geFeatured on Findly.toolsFeatured on Findly.toolsFeatured on Startup FameFeatured on Startup FameFeatured on LaunchKiwiFeatured on LaunchKiwiFeatured on ScrollLaunchFeatured on ScrollLaunchFeatured on DailyPingsFeatured on DailyPingsFazier badgeFazier badgeFeatured on NewTool.siteFeatured on NewTool.siteFeatured on saasfame.comFeatured on saasfame.comDR Checker - Domain RatingDR Checker - Domain RatingListed on Turbo0Listed on Turbo0Launched on LaunchBoard - Product Launch PlatformLaunched on LaunchBoard - Product Launch PlatformList on SimilarlabsList on Similarlabshttps://codetrendy.comhttps://codetrendy.comListed on DevTool.ioFeatured on BuildlistFeatured on BuildlistLaunched on Tiny StartupsFeatured on ShowMeBestAIFeatured on ShowMeBestAIFind us on LaunchZoneFind us on LaunchZone
Ā© 2026 Jackalope Digital LLC. All rights reserved.
  1. Home
  2. šŸ—„ļø Databases
  3. SmartDB MCP
SmartDB MCP logo
Health: ActiveRecent health check succeeded.Last checked 9/11/2026, 9:16:27 PM

SmartDB MCP

User RatingsBe the first to rate and review this MCP server!
View Repository80 GitHub StarsTotal stargazers on GitHub for the source repository (80 stars).Visit Website
databasesqloauth2mcpmulti-database

Universal MCP server for multi-database access with SQL execution, health checks, optimization, and OAuth 2.0 support.

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to CursorAdd to VS Code
We couldn’t automatically confirm this listing starts correctly

The install command below didn't complete successfully in our automated test.

uvx SmartDB-MCP

Downloading cryptography (4.5MiB) Downloading pydantic-core (2.0MiB) Downloading pymssql (3.0MiB) Downloading psycopg2-binary (4.1MiB) Downloading sqlalchemy (3.2MiB) Downloading oracledb (2.6MiB) Downloaded pydantic-core Downloaded pymssql Downloaded oracledb Downloaded psycopg2-binary Downloaded cryptography Building cx-oracle==8.3.0 Downloaded sqlalchemy Ɨ Failed to build `cx-oracle==8.3.0` ā”œā”€ā–¶ The build backend returned an error ╰─▶ Call to `setuptools.build_meta.build_wheel`

This is an experimental automated check and can have false negatives — missing environment variables, a slow cold install, etc. It doesn’t necessarily mean something’s wrong. Last checked 1mo ago.

Manual Client & Custom JSON ConfigExpand JSON ā–¾

Client Config & Setup

Choose your client or environment
Target File:~/Library/Application Support/Claude/claude_desktop_config.json
claude_desktop_config.json
{
  "mcpServers": {
    "wenb1n-dev-smartdb-mcp": {
      "command": "uvx",
      "args": [
        "SmartDB-MCP"
      ]
    }
  }
}

šŸ’” Paste the JSON block into your client's configuration file under mcpServers, then restart the application.

Install Tool Schemas (8) Directory Badge Claim listing AlternativesšŸ—„ļø More in Databases

Overview

This MCP server acts as a universal database gateway supporting simultaneous connections to multiple mainstream databases including MySQL, PostgreSQL, Oracle, SQL Server, and Dameng. It provides tools for executing SQL commands, analyzing database health, optimizing SQL queries, and inspecting table structures and indexes. OAuth 2.0 authentication is integrated for secure access, and the server supports Streamable HTTP, SSE, and STDIO protocols. It is designed for developers needing a customizable, extensible MCP interface to manage and explore diverse databases.

Use cases

•Connect to multiple heterogeneous databases simultaneously
•Execute and manage SQL queries with permission control
•Perform health diagnostics and get optimization suggestions
•Query database schema details such as tables and indexes
•Integrate OAuth 2.0 authentication for secure access

Key features

•Supports MySQL, PostgreSQL, Oracle, SQL Server, Dameng
•SQL execution tool with broad command support
•Database health analysis with diagnostic reports
•SQL performance optimization based on execution plans
•OAuth 2.0 authentication integration
•Supports Streamable HTTP, SSE, and STDIO protocols

Capabilities & Tool Schemas (8) ~284 tokensApproximate context cost of this server’s tool schemas (~4 chars/token), before any tool is called. Actual usage depends on your client and model.Self-reported Self-reportedParsed from the repository README, not verified against a live server — may be incomplete or out of date.

Inspect callable tools, capabilities, and parameters exposed to AI agents by SmartDB MCP.

execute_sql

SQL execution tool that can execute ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE", "CREATE", "ALTER", "DROP", "TRUNCATE"] commands based on permission configuration

get_db_health

Analyzes database health status (connection status, transaction status, running status, lock detection) and outputs professional diagnostic reports and solutions

get_table_desc

Searches for table structures in the database based on table names, supports multi-table queries

get_table_index

Searches for table indexes in the database based on table names, supports multi-table queries

get_table_name

Database table name query tool. Used to query all table names in the database or search for corresponding table names based on Chinese table names or table descriptions

get_db_version

Database version query tool

Documentation Overview

简体中文 English MseeP.ai Security Assessment Badge

image

SmartDB

SmartDB is a universal database gateway that implements the Model Context Protocol (MCP) server interface. This gateway allows MCP-compatible clients to connect and explore different databases.

Compared to similar products, SmartDB not only provides basic database connection and exploration capabilities but also adds advanced features such as OAuth 2.0 authentication , health checks, SQL optimization, and index health detection, making database management and maintenance more secure and intelligent.

image

Currently Supported Databases

DatabaseSupportDescription
MySQL√Supports MySQL 5.6+, MariaDB 10+
PostgreSQL√Supports PostgreSQL 9.6+, YMatrix
Oracle√Oracle 12+
SQL Server√Microsoft SQL Server 2012+
Dameng√Dameng 8.0+

Tool List

Tool NameDescription
execute_sqlSQL execution tool that can execute ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE", "CREATE", "ALTER", "DROP", "TRUNCATE"] commands based on permission configuration
get_db_healthAnalyzes database health status (connection status, transaction status, running status, lock detection) and outputs professional diagnostic reports and solutions
get_table_descSearches for table structures in the database based on table names, supports multi-table queries
get_table_indexSearches for table indexes in the database based on table names, supports multi-table queries
get_table_nameDatabase table name query tool. Used to query all table names in the database or search for corresponding table names based on Chinese table names or table descriptions
get_db_versionDatabase version query tool
sql_creatorSQL query generation tool that generates corresponding SQL query statements based on different database types
sql_optimizeA professional SQL performance optimization tool that provides expert optimization suggestions based on execution plans, table structure information, table data volume, and table indexes.

Usage

Environment Configuration File Description

bash
# Database configuration file path
DATABASE_CONFIG_FILE=/Volumes/SmartDB/src/config/database_config.json

#========OAuth2========
# OAuth2 client ID
CLIENT_ID=smart_db_client_id
# OAuth2 client secret
CLIENT_SECRET=smart_db_client_secret
# Access token expiration time (minutes)
ACCESS_TOKEN_EXPIRE_MINUTES=30
# Refresh token expiration time (days)
REFRESH_TOKEN_EXPIRE_DAYS=30
# Token encryption key
TOKEN_SECRET_KEY=smart_db_token_secret
# Username
OAUTH_USER_NAME=admin
# Password
OAUTH_USER_PASSWORD=wenb1n

Note: If you adjust the client ID and key in the oauth configuration, please also modify the corresponding configuration in the static/config file in the previous code

Database Connection Configuration Description

config.json
{
  "default": {
    "host": "192.168.xxx.xxx",
    "port": 3306,
    "user": "root",
    "password": "root",
    "database": "a_llm",
    "role": "readonly",
    "pool_size": 10,
    "max_overflow": 20,
    "pool_recycle": 3600,
    "pool_timeout": 30,
    "type": "mysql"
  },
  "postgresql": {
    "host": "192.168.xxx.xxx",
    "port": 5432,
    "user": "postgres",
    "password": "123456",
    "database": "postgres",
    "schema": "public",
    "role": "readonly",
    "pool_size": 5,
    "max_overflow": 10,
    "pool_recycle": 3600,
    "pool_timeout": 30,
    "type": "postgresql"
  },
  "oracle": {
    "host": "192.168.xxx.xxx",
    "port": 1521,
    "user": "U_ORACLE",
    "password": "123456",
    "database": "123456",
    "service_name": "ORCL",
    "role": "readonly",
    "pool_size": 5,
    "max_overflow": 10,
    "pool_recycle": 3600,
    "pool_timeout": 30,
    "type": "oracle"
  },
  "mssql": {
    "host": "192.168.xxx.xxx",
    "port": 1433,
    "user": "test",
    "password": "123456",
    "database": "TEST",
    "schema": "dbo",
    "role": "readonly",
    "pool_size": 5,
    "max_overflow": 10,
    "pool_recycle": 3600,
    "pool_timeout": 30,
    "type": "mssqlserver"
  }
}
  • Database Connection Parameter Description

The following table details the meaning and usage of each parameter in the database connection configuration file:

ParameterRequiredTypeDescription
hostYesstringDatabase server address
portYesintegerDatabase server port number
userYesstringDatabase username
passwordYesstringDatabase user password
databaseYesstringDatabase name to connect to
roleYesstringUser role, such as "readonly" for read-only permissions
pool_sizeYesintegerConnection pool size
max_overflowYesintegerMaximum overflow connections in connection pool
pool_recycleYesintegerConnection pool recycle time (seconds)
pool_timeoutYesintegerConnection pool timeout time (seconds)
typeYesstringDatabase type, such as "mysql", "postgresql", "oracle", "mssqlserver"
  • Additional Parameters for Specific Databases
ParameterDatabase TypeRequiredTypeDescription
schemaPostgreSQL, SQL ServerNostringDatabase schema
service_nameOracleNostringOracle service name
  • role permission control configuration items and corresponding database permissions: readonly (readonly), read/write (writer), administrator (admin)
Code
    "readonly": ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN"],  # readonly permission
    "writer": ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE"],  # read/write permission
    "admin": ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE", 
             "CREATE", "ALTER", "DROP", "TRUNCATE"]  # administrator permission
  • Note

"default" is the default database connection configuration and must be configured. Other database configurations should be added as needed.

pip installation and configuration

Terminal
pip install SmartDB-MCP

Parameter explanation
--mode: transmission mode ("stdio", "sse", "streamablehttp")
--envfile path of the environment variable file
--oauth enable oauth authentication (currently only supported in "streamablehttp" mode)

Start command:
 smartdb --envfile=/Volumes/config/.env --oauth=true


Docker Startup

Quick Start

1. Build and Start Service

bash
# Start service using docker-compose
docker-compose up -d

# Check service status
docker-compose ps

# View logs
docker-compose logs -f smartdb

2. Manual Image Building

bash
# Build image
docker build -t smartdb-mcp:latest .

# Run container
docker run -d \
  --name smartdb-mcp-server \
  -p 3000:3000 \
  -e DATABASE_CONFIG_FILE=/app/src/config/database_config.json \
  -e CLIENT_ID=smart_db_client_id \
  -e CLIENT_SECRET=smart_db_client_secret \
  -e TOKEN_SECRET_KEY=your_secret_key \
  -v $(pwd)/src/config:/app/src/config:ro \
  -v $(pwd)/logs:/app/logs \
  smartdb-mcp:latest

Code Startup

Local Development Streamable Http Mode

  • Start service using uv

Add the following content to your MCP client tools, such as cursor, cline, etc.

MCP JSON as follows:

config.json
{
  "mcpServers": {
    "smartdb": {
      "name": "smartdb",
      "type": "streamableHttp",
      "description": "",
      "isActive": true,
      "url": "http://localhost:3000/mcp/"
    }
  }
}

Start command:

bash
# Download dependencies
uv sync

# Start
uv run -m core.server

# Custom env file location
uv run -m core.server --envfile /path/to/.env

Local Development SSE Mode

  • Start service using uv

Add the following content to your MCP client tools, such as cursor, cline, etc.

MCP JSON as follows:

config.json
{
  "mcpServers": {
    "smartdb": {
      "name": "smartdb",
      "description": "",
      "isActive": true,
      "url": "http://localhost:3000/sse"
    }
  }
}

Start command:

bash
# Download dependencies
uv sync

# Start
uv run -m core.server --mode sse

# Custom env file location
uv run -m core.server --mode sse --envfile /path/to/.env

Local Development STDIO Mode

Add the following content to your MCP client tools, such as cursor, cline, etc.

Read the full README →View source on GitHub →

Related MCP Servers

View all in Databases View all alternatives
  • Mysql MCP Server Pro logoMysql MCP Server Pro

    Supports SSE, STDIO; not only limited to MySQL's CRUD functionality; also includes database exception analysis capabilities; controls database permissions based on roles; and makes it easy for developers to extend tools with customization

    šŸ—„ļø Databases2 views
    Compare vs Mysql MCP Server Pro →
  • Db MCP Server logoDb MCP Server

    A high-performance multi-database MCP server built with Golang, supporting MySQL & PostgreSQL (NoSQL coming soon). Includes built-in tools for query execution, transaction management, schema exploration, query building, and performance analysis, with seamless Cursor integration for enhanced database workflows.

    šŸ—„ļø Databases1 views
    Compare vs Db MCP Server →
  • MCP Server Mysql logoMCP Server Mysql

    MySQL database integration in NodeJS with configurable access controls and schema inspection

    šŸ—„ļø Databases3 views
    Compare vs MCP Server Mysql →
  • Influxdb3 MCP Server logoInfluxdb3 MCP Server
    Verified

    Official MCP server for InfluxDB 3 Core/Enterprise/Cloud Dedicated

    šŸ—„ļø Databases2 views
    Compare vs Influxdb3 MCP Server →

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

GitHub stars
80
Stargazers on the source repository.
Last commit
12mo ago
Most recent push to the default branch.
Install check
Inconclusive
Install command did not finish in our automated test.
Tools exposed
8
Callable tools this server registers over MCP.
Directory activity
2 views
Config copies, upvotes, and views on AllMCPs.

Reviews

No reviews yet — be the first to share how this listing worked for you.

Frequently Asked Questions about SmartDB MCP

Supports MySQL 5.6+, MariaDB 10+, PostgreSQL 9.6+, Oracle 12+, SQL Server 2012+, and Dameng 8.0+.

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:
Live Dynamic SVG PreviewSmartDB MCP AllMCPs Directory Badge
Markdown (GitHub README)
[![AllMCPs](https://allmcps.com/api/badge/wenb1n-dev-smartdb-mcp?style=directory)](https://allmcps.com/mcp/wenb1n-dev-smartdb-mcp)
HTML Embed
<a href="https://allmcps.com/mcp/wenb1n-dev-smartdb-mcp"><img src="https://allmcps.com/api/badge/wenb1n-dev-smartdb-mcp?style=directory" alt="SmartDB MCP on AllMCPs" /></a>

Technical Specs & Signals

CategoryšŸ—„ļøDatabases
PricingFree
More technical detailsExpand ā–¾
TransportSTDIO
RuntimePython
AuthAPI key
Last updatedAug 9, 2026
10/11 checks healthy over the last 33d
Views2
Unique ViewsTotal visits recorded for this listing page on AllMCPs.
Installs0
Installs & Copy ActionsTotal times users copied install commands or configuration snippets for this server.
GitHub stars80
GitHub Star CountTotal stargazers on GitHub representing community popularity (80 stars).
Last commit12mo ago
Last Repository CommitThe most recent commit or push recorded for this server's GitHub repository.Last commit on Sep 14, 2025
59Quality signal: Good Ā· 59/100How this signal is calculated ā–¾
Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership10/20
Documentation & tools30/30
Adoption & activity4/15
Community engagement0/10

A guidance signal from public completeness & health data — not a user rating. New listings start lower and rise as they add docs, get verified, and grow adoption. Signals we can't observe for a listing are skipped, not counted against it.

Supply-chain signal

No high-severity advisories surfaced by our automated scan.

Critical 0High 0Medium 0Low 0

Scanned 23d ago via OSV.dev Ā· SmartDB-MCP (PyPI)

ā˜… FeaturedAllMCPs Server logo

AllMCPs Server

The official MCP server for AllMCPs.com - submit and manage tools directly from your AI. The open directory for MCP servers. Connect Claude, Cursor, Windsurf, and AI agents to databases, tools, files, and APIs. Explore 10,000+ servers. AllMCPs is the premier, open directory for discovering, evaluating, and installing Model Context Protocol (MCP) servers to equip AI agents and LLMs with real-world superpowers.

Explore Server →

Own this project?

This directory is pre-filled from public sources. Claim via GitHub README, site badge, or DNS TXT to unlock edit access and the Official badge — proof is checked automatically, then reviewed by our team.

Free dofollow backlink: add your website and place the AllMCPs badge on it — no claim needed. We detect it automatically and keep it verified as long as the badge stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in šŸ—„ļø Databases →Best MCP servers for Databases →Alternatives to SmartDB MCP →Install in Claude DesktopInstall in CursorInstall in VS Code