MEC-Postgres

MEC-Postgres

0
databases

MEC PostgreSQL is a Model Context Protocol server specifically designed for facilitating interaction with PostgreSQL databases. It enables inspection of schemas and execution of both read and write queries, supporting cloud-based applications like Claude Desktop.

MEC PostgreSQL

A Model Context Protocol server offering read and write access to PostgreSQL databases. Key features include:

  • query: Executes read-only SQL queries within a READ ONLY transaction.
  • uploadCsv: Uploads and processes CSV files into database tables within a READ AND WRITE transaction.
  • Provides JSON schema information for each table including column names and data types.

Usage with Claude Desktop

Add configurations to "mcpServers" in claude_desktop_config.json to use with the Claude Desktop app. Replace /mydb with your database name.

Docker

Guidelines for running Docker and building the server container.

License

Licensed under the MIT License, allowing free use, modification, and distribution.