A
licenseNot graded
qualityD
maintenanceMCP server for connecting to databases (PostgreSQL, MySQL, SQL Server, Redis) enabling SQL queries, table exploration, and Redis key-value operations.
1
MIT
mcp_db
Enables retrieval of database metadata (tables, columns, relationships, dependencies) from PostgreSQL databases, supporting search, object description, and dependency analysis.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@mcp_dbshow me the relationships for the orders table"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
mcp_db — MCP-сервер метаданных корпоративных БД
MCP-сервер для Cursor: структура таблиц, неявные связи (из JOIN/WHERE в процедурах, функциях, триггерах и VIEW), зависимости объектов, экспорт в PlantUML.
Статус
v0.1.0 — каркас, metadata store, HTTP MCP-сервер, SQL-анализатор, extractors MS SQL / PostgreSQL, индексация refresh.
Related MCP server: onec-meta-mcp
Быстрый старт
cd MCP_DB
python -m venv .venv311
.venv311\Scripts\activate
pip install -e ".[dev]"
copy config\config.example.yaml config\config.yaml
# задать GBD_USER, GBD_PASSWORD и т.д.
python -m mcp_db refresh --verbose
python -m mcp_db serveСервер: http://0.0.0.0:8765/mcp (Streamable HTTP). Health: http://localhost:8765/health.
MCP Tools
Tool | Описание |
| Источники и время индексации |
| Поиск объектов |
| Колонки и определение |
| Входящие/исходящие зависимости |
| Граф связей, PlantUML / Mermaid |
| Дерево зависимостей |
| Запуск индексации |
| Выполнение SQL (если |
Права учётной записи БД: docs/db-permissions.md.
Документация
Документ | Содержание |
Техническое задание | |
Развёртывание | |
Права пользователя БД (MS SQL, PostgreSQL) |
Тесты
pytestDocker
docker compose -f docker/docker-compose.yml up -dThis server cannot be deployed
Maintenance
ActivityStale
ResponsivenessNo issues
Related MCP Connectors
2,000+ MCP servers read at source level. Know what one does before you connect. Free, no key.
MCP server for querying and analyzing data from ad platforms, analytics tools, and spreadsheets
- SchemaOAuthai.schemalabs
The AI that understands raw data: Schema over your tables and databases, as MCP tools.
MCP server for Russian books search, details, and recommendation candidates.
Related MCP Servers
- FlicenseNot gradedqualityBmaintenanceMCP server for searching and analyzing 1C enterprise metadata and BSL code using a SQLite backend. Enables querying configuration structure, code routines, and performing compliance checks via natural language.-
- AlicenseBqualityCmaintenanceMCP server for accessing Oracle databases, enabling schema exploration, query execution, and performance analysis.12MIT
- AlicenseNot gradedqualityCmaintenanceEnterprise-grade MCP server for Microsoft SQL Server, enabling semantic schema discovery, table profiling, safe data operations with preview/confirm, and multi-environment support.33MIT