MEC PostgreSQL Server

Example Use Cases

• 1

  Inspect database schemas and column types before constructing queries.

• 2

  Execute read-only analytics and SELECT queries safely within a READ ONLY transaction.

• 3

  Upload CSV data and perform transactional read-and-write operations on a PostgreSQL database.

Description

This MCP server provides tools and resources to let agents discover table schemas and run SQL against a connected PostgreSQL database. It exposes a read-only 'query' tool for executing SELECT-style queries inside a READ ONLY transaction and an 'uploadCsv' tool that processes CSVs and runs SQL in a READ AND WRITE transaction. Schema metadata for each table is automatically discovered and exposed as JSON resources. The project is distributed with a Dockerfile and licensed under the MIT License.