NeoSQL MCP vs SmartDB MCP
A side-by-side look at the NeoSQL MCP and SmartDB MCP MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
N
NeoSQL MCPDatabases · Local subprocess (stdio)Schemas, SQL, ERDs, and codegen for PostgreSQL, MySQL, Oracle, SQLite, and more via NeoSQL Desktop.60GoodAuth: no auth requiredVerdict: choose NeoSQL MCP for databases work as a local process; choose SmartDB MCP for databases as a local process. You can also run both side by side in one mcpServers block.
Which MCP server should you choose?
NChoose NeoSQL MCP when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- Its auth model fits you: No auth required.
- You want tools like
ping, get-mcp-session-id, list-connections.
Choose SmartDB MCP when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- Its auth model fits you: OAuth 2.0.
- You have the keys it needs:
DATABASE_CONFIG_FILE, CLIENT_ID, CLIENT_SECRET, ACCESS_TOKEN_EXPIRE_MINUTES, REFRESH_TOKEN_EXPIRE_DAYS, TOKEN_SECRET_KEY, OAUTH_USER_NAME, OAUTH_USER_PASSWORD. - You want tools like
execute_sql, get_db_health, get_table_desc.
Feature & specification comparison
Rows where the two servers differ are marked.
| Spec | N NeoSQL MCP | |
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 60/100 · Good | 57/100 · Good |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Local subprocess (stdio) |
| Auth | No auth required | OAuth 2.0 |
| Pricing | Free | Free |
| Required env vars | None listed | DATABASE_CONFIG_FILECLIENT_IDCLIENT_SECRETACCESS_TOKEN_EXPIRE_MINUTESREFRESH_TOKEN_EXPIRE_DAYSTOKEN_SECRET_KEYOAUTH_USER_NAMEOAUTH_USER_PASSWORD |
| Verified owner | Community listing | Community listing |
| GitHub stars | 1 | 77 |
| Directory activity | 0 views 0 installs 0 upvotes | 3 views 0 installs 0 upvotes |
| Tools | 10 | 8 |
| Full listing | View NeoSQL MCP | View SmartDB MCP |
Tools & capabilities
NeoSQL MCP tools 10
pingReturns `pong` for a lightweight MCP health check.get-mcp-session-idDiagnostic tool that returns the upstream session id used by this process.list-connectionsLists MCP-enabled NeoSQL connections and schemas for the current project.get-context-helpExplains active-project Default and explicit target usage.list-tablesLists tables.get-table-detailsReturns columns, keys, indexes, and related table metadata.erd-create-tablesAdds virtual tables to an ERD without changing the database.erd-modify-tablesModifies virtual ERD table models without changing the database.execute-queryExecutes SQL, including DDL.generate-codeGenerates and saves source files for specified tables using template packs configured in Project Settings. Requires template packs, required variables, and an output folder (Location). May overwrite existing files without an additional confirmation dialog.
SmartDB MCP tools 8
execute_sqlSQL execution tool that can execute ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE", "CREATE", "ALTER", "DROP", "TRUNCATE"] commands based on permission configurationget_db_healthAnalyzes database health status (connection status, transaction status, running status, lock detection) and outputs professional diagnostic reports and solutionsget_table_descSearches for table structures in the database based on table names, supports multi-table queriesget_table_indexSearches for table indexes in the database based on table names, supports multi-table queriesget_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 descriptionsget_db_versionDatabase version query toolsql_creatorSQL query generation tool that generates corresponding SQL query statements based on different database typessql_optimizeA professional SQL performance optimization tool that provides expert optimization suggestions based on execution plans, table structure information, table data volume, and table indexes.
Ready-to-paste client configs
Paste either block (or both) into your client config, e.g. claude_desktop_config.json or ~/.cursor/mcp.json. We only show a config when the install command is confirmed.
NeoSQL MCP
{
"mcpServers": {
"neosql-mcp": {
"command": "npx",
"args": [
"-y",
"neosql-mcp"
]
}
}
}
SmartDB MCP
{
"mcpServers": {
"wenb1n-dev-smartdb-mcp": {
"command": "uvx",
"args": [
"SmartDB-MCP"
],
"env": {
"DATABASE_CONFIG_FILE": "YOUR_DATABASE_CONFIG_FILE_HERE",
"CLIENT_ID": "YOUR_CLIENT_ID_HERE",
"CLIENT_SECRET": "YOUR_CLIENT_SECRET_HERE",
"ACCESS_TOKEN_EXPIRE_MINUTES": "YOUR_ACCESS_TOKEN_EXPIRE_MINUTES_HERE",
"REFRESH_TOKEN_EXPIRE_DAYS": "YOUR_REFRESH_TOKEN_EXPIRE_DAYS_HERE",
"TOKEN_SECRET_KEY": "YOUR_TOKEN_SECRET_KEY_HERE",
"OAUTH_USER_NAME": "YOUR_OAUTH_USER_NAME_HERE",
"OAUTH_USER_PASSWORD": "YOUR_OAUTH_USER_PASSWORD_HERE"
}
}
}
}
Frequently asked questions
NeoSQL MCP is categorized under Databases and uses a local stdio subprocess. SmartDB MCP belongs to Databases and uses a local stdio subprocess. Pick NeoSQL MCP for databases work and SmartDB MCP for databases.
Copy the mcpServers block from the config section on this page into your client's config (for example claude_desktop_config.json or ~/.cursor/mcp.json), then fully restart the client.
NeoSQL MCP is listed as free. Auth: no auth required. SmartDB MCP is listed as free. Auth: oauth 2.0. If a server needs environment variables such as API keys, define them under the env key in your client's MCP config.
Yes. MCP clients support multiple servers: add neosql-mcp and wenb1n-dev-smartdb-mcp as separate keys in the same mcpServers object, and your assistant will call tools from either one.
On AllMCPs, NeoSQL MCP has a quality signal of 60/100 (Good) with 0 views, 0 installs and 1 GitHub stars. SmartDB MCP has 57/100 (Good) with 3 views, 0 installs and 77 GitHub stars.