Pgsql
Enables AI assistants to interact with a PostgreSQL database through the Model Context Protocol.
About
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
- Lists user tables in the database with optional schema filtering
- 1 GitHub stars
- Executes SELECT queries on PostgreSQL databases
- Executes INSERT, UPDATE, and DELETE queries
- Creates new tables in PostgreSQL
Use Cases
- Allowing AI assistants to dynamically query and analyze data stored in PostgreSQL databases
- Enabling AI agents to create and modify database schemas based on user requests
- Automating database management tasks through AI-driven commands
Sponsored