Developer Tools

Schema Discovery MCP Server

Connect your account, then chat with AI to run tools.

Understand database structure, relationships, and dependencies. Explore tables, foreign keys, functions, triggers, and understand how your database is organized.

10 tools
Agent guide included
Start Chatting

Opens MCPBundles Studio with this server selected. After sign-in, chat and run tools from the same thread.

Browse all tools

AI Skill
SKILL.md

Domain knowledge for Schema Discovery — workflow patterns, data models, and gotchas for your AI agent.

PostgreSQL — Schema Discovery

Map columns and constraints, visualize foreign-key graphs, understand dependency order for migrations, inventory stored procedures and triggers, and highlight tables that no longer receive writes.

Tools in this Server (10)

Postgres Find Unused Tables

Find tables that are not referenced by foreign keys, views, materialized views, or functions. Useful for identifying orphaned tables that may be safe ...

Postgres Get Ai Description

Get compact, token-efficient database schema description optimized for AI text-to-SQL. Returns tables with columns, types, relationships, and sample v...

Postgres Get Enum Values

Find columns with enum-like behavior (limited distinct values) and show value frequencies. Useful for understanding categorical data and identifying c...

Postgres Get Foreign Key Graph

Build a graph representation of foreign key relationships showing which tables reference which other tables. Returns nodes (tables) and edges (FK rela...

Postgres Get Table Dependencies

Find all database objects that depend on a table: views, materialized views, triggers, and functions. Critical before dropping or altering tables.

Postgres Inspect Schema

Inspect PostgreSQL schema or table in detail. Get detailed information about tables, columns, relationships, indexes, and constraints.

Postgres List Functions

List PostgreSQL stored procedures and functions with their parameters, return types, and definitions. Useful for understanding database logic and stor...

Postgres List Tables

List PostgreSQL tables with rich filtering and metadata options. Supports pattern matching, schema filtering, and optional inclusion of columns, relat...

Postgres List Triggers

List PostgreSQL triggers with their event types (INSERT, UPDATE, DELETE), timing (BEFORE, AFTER), and action statements. Essential for understanding d...

Search

Search PostgreSQL database using SQL queries or structured syntax. Returns ranked results with IDs and titles. Supports SELECT statements and table br...

Frequently Asked Questions

What is the Schema Discovery MCP server?

Understand database structure, relationships, and dependencies. Explore tables, foreign keys, functions, triggers, and understand how your database is organized. It provides 10 tools that AI agents can use through the Model Context Protocol (MCP).

How do I connect Schema Discovery to my AI agent?

Add the MCPBundles server URL to your MCP client configuration (Claude Desktop, Cursor, VS Code, etc.). The URL format is: https://mcp.mcpbundles.com/bundle/postgres-schema-discovery. Authentication is handled automatically.

How many tools does Schema Discovery provide?

Schema Discovery provides 10 tools that can be called by AI agents, along with a SKILL.md that gives your AI agent domain knowledge about when and how to use them.

What authentication does Schema Discovery require?

Schema Discovery uses API Key. PostgreSQL requires credentials. Connect via MCPBundles and authentication is handled automatically.

Setup Instructions

Connect Schema Discovery to any MCP client in minutes

https://mcp.mcpbundles.com/bundle/postgres-schema-discovery

What is MCP?

Model Context Protocol lets AI tools call external capabilities securely through a single URL. This bundle groups tools behind an MCP endpoint that many clients can use.

Use this bundle in 3 steps

  1. Copy the MCP URL above
  2. Open your AI tool and add a new MCP/connector
  3. Paste the URL and follow any auth prompts

Claude Desktop Users

Skip the manual setup! Use the .mcpb file format for one-click installation. Check the Claude Desktop tab for setup instructions.

Pick your tool tab for exact steps

Select ChatGPT, Cursor, Claude Code, or another tab for copy-paste config.

Ready to use Schema Discovery?

Sign in to connect your credentials and start running tools from the chat.

Schema Discovery MCP Server & Skill — 10 Tools