PostgreSQL

概要

PostgreSQL provides an MCP server designed to connect AI-powered clients like Claude Code, Claude Desktop, and Cursor to PostgreSQL databases. It offers extensive capabilities for database operations, including secure SQL query execution (read-only by default with SQL injection prevention), detailed schema exploration, table analysis, and performance optimization. The tool integrates guided workflows (MCP Prompts) and browsable database structures (MCP Resources) to enhance usability, making database interaction intuitive and efficient for both exploration and management tasks.

主な機能

• Guided Database Workflows via MCP Prompts
• Table Performance Analysis and Optimization (EXPLAIN plans, statistics)
• Secure Query Execution with read-only default and SQL injection prevention
• Browsable Database Structure as MCP Resources
• Comprehensive Schema Exploration (tables, views, functions)
• 2 GitHub stars

ユースケース

• Database schema exploration and discovery using natural language
• Performance analysis and optimization of database tables and queries
• Efficient and secure data querying and retrieval