Db Metadata Extractor MCP 伺服器 | PlugMCP
跳到正文 mcp-name: io.github.Optisol-Business/db-metadata-extractor-mcp
Database Metadata Extractor MCP Server
A Model Context Protocol (MCP) server that extracts and queries database schema metadata from PostgreSQL, Snowflake, SQL Server, BigQuery, and Oracle databases.
Features
✅ Multi-database support : PostgreSQL, Snowflake, SQL Server (MSSQL), BigQuery, Oracle
Extract database metadata from PostgreSQL, Snowflake, SQL Server, BigQuery, and Oracle.
把任意工具接入任意代理。面向非開發者的 MCP 伺服器目錄;閘道承載流量,n8n 承載應用。
產品
目錄
開發者
公司
2026-11-09
✅ Complete schema extraction : Tables, columns, primary keys, indexes, constraints
✅ Local JSON output : Saves metadata directly to local folder (no cloud required)
✅ Query interface : Search and filter metadata by table/column names
✅ Pagination support : Browse large schemas efficiently
✅ VS Code integration : Works with VS Code Agent Mode
✅ CLI customizable : Transport options (stdio, HTTP)
Installation
From PyPI pip install db-metadata-extractor-mcp
From Source git clone https://github.com/Optisol-Business/db-metadata-extractor-mcp.git
cd db-metadata-extractor-mcp
pip install -e .
Quick Start
1. Start the MCP Server db-metadata-extractor-mcp
The server starts in stdio mode by default and listens for MCP client connections.
2. Configure in Claude Desktop Add to ~/.config/Claude/claude_desktop_config.json (macOS/Linux) or %APPDATA%\Claude\claude_desktop_config.json (Windows):
{
"mcpServers": {
"db-metadata-extractor": {
"command": "db-metadata-extractor-mcp",
"args": [],
"env": {}
}
}
}
3. Use in Claude
Extract metadata from my PostgreSQL database and save it to /tmp/output
Claude will use the server's tools to extract and query your database schema.
Tools
extract_metadataExtracts complete schema metadata from a database.
db_type (required): postgresql, snowflake, sqlserver, bigquery, oracle
output_path (required): Local directory for JSON output
database_name: Database/schema name
host: Database host (not needed for BigQuery/Snowflake)
port: Database port
username: Database user
password: Database password
schema_name: Specific schema (optional)
tables: Array of table names to extract (optional)
account: Snowflake account ID
warehouse: Snowflake warehouse
role_name: Snowflake role
project_id: BigQuery project ID
service_account_key: BigQuery service account JSON (base64 encoded)
File path where metadata was saved
Summary statistics (table count, column count, etc.)
query_metadataQuery previously extracted metadata.
filepath (required): Path to metadata JSON file
table_name: Filter by table name (substring match)
field_name: Filter by column name (substring match)
page: Page number (default: 1)
page_size: Results per page (default: 20)
Paginated table results matching filters
Examples
PostgreSQL # Via Claude
"Extract all tables from my dev PostgreSQL database at localhost:5432"
Parameters Claude will use:
{
"db_type": "postgresql",
"host": "localhost",
"port": 5432,
"database_name": "dev_db",
"username": "postgres",
"password": "your_password",
"output_path": "/tmp/db_metadata"
}
Snowflake "Extract schema from Snowflake account XYZ123"
{
"db_type": "snowflake",
"account": "XYZ123",
"username": "your_user",
"password": "your_password",
"warehouse": "COMPUTE_WH",
"role_name": "ANALYST",
"database_name": "PRODUCTION",
"output_path": "C:/metadata"
}
BigQuery "Extract metadata from BigQuery project my-project-123"
{
"db_type": "bigquery",
"project_id": "my-project-123",
"service_account_key": "base64_encoded_json_key",
"output_path": "/tmp/bq_metadata"
}
Advanced Usage
Custom Transport Start with HTTP transport:
db-metadata-extractor-mcp --transport streamable-http --port 3000
Environment Variables # Set database credentials via env
export DB_HOST=localhost
export DB_USER=postgres
export DB_PASSWORD=secret
db-metadata-extractor-mcp
Output Format The extracted metadata is saved as a JSON file with structure:
{
"source": {
"db_type": "postgresql",
"extracted_at": "2026-04-09T14:30:00",
"host": "localhost"
},
"schemas": [
{
"schema_name": "public",
"tables": [
{
"table_name": "users",
"columns": [
{
"column_name": "id",
"data_type": "int",
"is_nullable": false,
"is_primary_key": true
},
{
"column_name": "email",
"data_type": "varchar",
"is_nullable": false
}
],
"indexes": [
{
"index_name": "users_email_idx",
"columns": ["email"]
}
]
}
]
}
]
}
Requirements
Python 3.8+
For PostgreSQL: psycopg2-binary
For Snowflake: snowflake-connector-python
For SQL Server: pyodbc, pymssql
For BigQuery: google-cloud-bigquery
For Oracle: oracledb
Troubleshooting
Connection Errors Problem : "Unable to connect to database"
Solution : Verify credentials and network access:
# Test PostgreSQL connection
psql -h localhost -U postgres -c "SELECT 1"
# Test Snowflake
snowsql -a XYZ123 -u your_user
Permission Errors Problem : "Access denied" or "insufficient permissions"
Solution : Ensure database user has:
SELECT on tables
USAGE on schemas
CONNECT on databases
Large Schema Timeouts Problem : Extraction times out on large databases
Solution : Extract specific schema/tables:
{
"schema_name": "public",
"tables": ["users", "orders"] // Specify subset
}
License MIT License - See LICENSE file
Contributing Contributions welcome! Please:
Fork the repository
Create feature branch
Submit pull request
Support
Links Graphify Turn any codebase, with its docs, SQL schemas, configs, and PDFs, into a queryable knowledge graph. A /graphify skill for Claude Code, Cursor, Codex, and Gemini CLI: local deterministic AST parsing, e Private Gpt Complete API layer for private AI applications on local models: RAG, skills, tools, MCP, text-to-sql, and more. Works with any OpenAI-compatible inference server. Scientific Agent Skills Turn any AI agent into an AI Scientist. The #1 Agent Skills library for science, used by 250,000+ scientists worldwide. 177 ready-to-use validated skills plus 100+ scientific databases covering biolog Open Code Review Secure, fast, efficient, battle-tested at Alibaba's scale. Hybrid architecture code review tool: deterministic pipelines + LLM Agent, precise line-level comments, built-in multi-language ruleset (NPE, Codebase Memory Local code intelligence for developers and AI agents. Connect code, docs and infrastructure in a persistent graph, with CBM Lens, MCP tools, agent integrations and change-aware test selection. Orm The Prisma ORM: write your application in TypeScript with human-readable queries instead of SQL. Host your database on Prisma Postgres and your app on Prisma Compute. OpenViking Self-evolving Context Database for AI Agents. Unify Agent Memory, Knowledge RAG and Skills. Context Mode Free, local plugin that keeps tool output out of your coding agent's context window. Sandbox and SQLite FTS5 search, 99% fewer bytes in context. Works with Claude Code, Codex, Pi, OMP, OpenCode, Gemin Dbx 25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Dock Xerj AI search engine and MCP server for bots and agents. One Rust binary indexes code, docs, logs, JSONL/CSV and PDFs for BM25 full-text, vector and hybrid search, code search without grep, agent memory a Wasp The batteries-included full-stack framework for the AI era. Develop JS/TS web apps (React, Node.js, and Prisma) using declarative code that abstracts away complex full-stack features like auth, backgr WrenAI GenBI (Generative BI) for AI agents, an open-source, governed text-to-SQL through an open context layer that turns natural-language questions into trusted dashboards, charts, and SQL across 20+ data s Databases MCP 伺服器 最佳 Databases MCP 伺服器
尚無工具清單。遠端伺服器會在首次健康檢查後取得工具清單。
如何安裝 Db Metadata Extractor? 在本頁複製適用於 Cursor、Claude Desktop、Claude Code 或 VS Code 的 stdio 設定。它使用發布者的安裝方式,而不是 PlugMCP 代理伺服器。
Db Metadata Extractor 需要 API 金鑰嗎? 這筆記錄未列出必要的環境變數。
Db Metadata Extractor 使用哪種傳輸方式? Db Metadata Extractor 透過 stdio 在本機執行。
Db Metadata Extractor 上次檢查是什麼時候? 上次檢查時間:2026-11-09。 Extract database metadata from PostgreSQL, Snowflake, SQL Server, BigQuery, and Oracle.
工具
0 / 10