PostgreSQL

概要

This Model Context Protocol server for PostgreSQL databases facilitates seamless interaction between Large Language Models (LLMs) and your database. It empowers LLMs with the capability to inspect database schemas, offering detailed JSON schema information for each table, including column names and data types, all automatically discovered from database metadata. Additionally, it allows LLMs to execute read-only SQL queries, ensuring data integrity by operating strictly within read-only transactions. This integration enhances LLMs' ability to understand database structures and efficiently retrieve information.

主な機能

• Include column names and data types in table schema output
• Designed as a Model Context Protocol (MCP) server for LLM integration
• Ensure all queries are executed within a read-only transaction for data safety
• 0 GitHub stars
• Automatically discover and provide JSON schema information for database tables
• Execute read-only SQL queries against connected databases

ユースケース

• Enabling Large Language Models (LLMs) to perform read-only queries on PostgreSQL databases for data retrieval
• Allowing LLMs to understand and inspect PostgreSQL database schemas and structures
• Integrating PostgreSQL database access into LLM-powered applications or environments like Claude Desktop and VS Code