Pgsql

概要

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.

主な機能

• 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

ユースケース

• 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