Db Metadata Extractor Mcp
Connects Claude to PostgreSQL, Snowflake, SQL Server, BigQuery, and Oracle databases to extract complete schema metadata including tables, columns, primary keys, indexes, and constraints. Exposes two tools: extract_metadata pulls the full schema and saves it as JSON to a local directory, while query_metadata lets you search and filter the extracted data by table or column names with pagination. Useful when you need to document database schemas, analyze structure across multiple databases, or give Claude context about your data model without writing custom queries. No cloud storage required, everything writes to your local filesystem. Handles large schemas through table filtering and paginated results.
- tools
- 2
- transport
- STDIO
- last updated
- Apr 16, 2026
Tools
2 toolsPublic tool metadata for what this MCP can expose to an agent.
extract_metadataExtracts complete schema metadata from a database.
Extracts complete schema metadata from a database.
No parameter schema in public metadata yet.
query_metadataQuery previously extracted metadata.
Query previously extracted metadata.
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageReadme
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
- ✅ 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
Details
- Repository
- github.com/optisol-business/db-metadata-extractor-mcp
- Categories
- Databases, Search & Web Crawling, Data & Analytics
- Package
db-metadata-extractor-mcp- Transport
- STDIO
- Registry
- MCP registry, active
Related Databases MCP servers
View all
MCP Toolbox for Databasesgoogleapis/mcp-toolboxMCP Toolbox for Databases enables your agent to connect to your database.16.9Kstars
Crawl4AI RAGcoleam00/mcp-crawl4ai-ragProvides web crawling, RAG, and knowledge-graph capabilities for AI agents with a Supabase-backed vector store.2.2Kstars
Monitorbetterdb-inc/monitorBetterDB MCP server - Valkey and Redis observability for Claude Code and other MCP clients1.3Kstars
Queryweaverfalkordb/queryweaverAn MCP server for Text2SQL: transforms natural language into SQL using graph schema understanding.1Kstars
Mcp Server Motherduckmotherduckdb/mcp-server-motherduckSQL analytics and data engineering for AI Assistants and IDEs540stars
Memory Vaultmihaibuilds/memory-vaultLocal-first AI memory layer with hybrid search. Postgres + pgvector. Self-hosted, MIT.67stars