Enables AI assistants to interact with a PostgreSQL database through the Model Context Protocol.
Pgsql enables seamless interaction between AI assistants and PostgreSQL databases using the Model Context Protocol (MCP). It provides AI agents with the ability to execute SQL queries, create tables, and list database tables. The server offers tools for reading and writing data, defining schemas, and managing database structures, facilitating dynamic database interactions driven by AI.
Key Features
01Lists user tables in the database with optional schema filtering
021 GitHub stars
03Executes SELECT queries on PostgreSQL databases
04Executes INSERT, UPDATE, and DELETE queries
05Creates new tables in PostgreSQL
Use Cases
01Allowing AI assistants to dynamically query and analyze data stored in PostgreSQL databases
02Enabling AI agents to create and modify database schemas based on user requests
03Automating database management tasks through AI-driven commands
