MEC-Postgres
If you are the rightful owner of MEC-Postgres and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Model Context Protocol server that provides read and write access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read and write queries.
MEC PostgreSQL is a Model Context Protocol (MCP) server designed to facilitate interaction with PostgreSQL databases. It allows Language Model Machines (LLMs) to perform both read and write operations on databases, making it a versatile tool for database management and data analysis. The server supports executing SQL queries and uploading CSV files into database tables, providing a comprehensive solution for database interaction. It also offers schema information for each table, which is automatically discovered from the database metadata, ensuring that users have access to up-to-date structural information about their databases. This server is particularly useful for applications that require dynamic database interactions, such as data-driven applications and AI models that need to process and analyze large datasets.
Features
- Read and write access to PostgreSQL databases
- Execution of read-only SQL queries
- CSV file upload and processing into database tables
- Automatic discovery of table schemas
- Support for dynamic database interactions
Tools
query
Execute read-only SQL queries against the connected database. All queries are executed within a READ ONLY transaction.
uploadCsv
Upload and process a CSV file into database tables. All queries are executed within a READ AND WRITE transaction.
