What is the difference between the query and uploadCsv tools?
`query` executes read-only SQL queries within a READ ONLY transaction; `uploadCsv` executes read and write queries within a READ AND WRITE transaction.
M
MEC Postgres MCP Server
@Pratye
Basic information
About MEC Postgres MCP Server
A Model Context Protocol server that provides read and write access to PostgreSQL databases. This server enables LLMs to inspect database schemas and execute read and write queries.
MEC Postgres MCP Server config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"postgres": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"mcp/postgres",
"postgresql://host.docker.internal:5432/mydb"
]
}
}
}MEC Postgres MCP Server tools
2Execute read-only SQL queries against the connected database
Upload and process a CSV file into database tables
Overview
What is MEC Postgres?
MEC Postgres is a Model Context Protocol (MCP) server that provides read and write access to PostgreSQL databases. It enables LLMs to inspect database schemas and execute SQL queries.
How to use MEC Postgres?
Use with Claude Desktop by adding the server configuration to the mcpServers section of claude_desktop_config.json. The server runs via Docker and connects to a PostgreSQL database using a connection URL (e.g., postgresql://user:password@host:port/db-name). Replace the database name and credentials as needed.
Key features of MEC Postgres
- Execute read-only SQL queries against PostgreSQL
- Upload and process CSV files into database tables
- Automatically discover table schemas as JSON resources
- Deploy via Docker for easy setup with Claude Desktop
- All queries use transactions (read-only or read-write)
Use cases of MEC Postgres
- Allow an LLM to explore database schema before generating queries
- Enable an LLM to execute analytical read queries on business data
- Let an LLM ingest CSV data into a PostgreSQL table for further analysis
- Provide database schema information to an LLM for context‑aware responses
Frequently asked questions
How do I connect to a PostgreSQL database?
Use a PostgreSQL connection URL (e.g., `postgresql://user:password@host:port/db-name`) when running the Docker container.
Does the server support authentication?
Yes, username and password can be included in the PostgreSQL connection URL.
What runtime is required to run MEC Postgres?
The server is distributed as a Docker image; Docker is required to run it.
More Databases MCP servers
MongoDB MCP Server
mongodb-jsA Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.
1.1K
PostgreSQL Model Context Protocol (PG-MCP) Server
stuzero540
Chroma MCP Server
chroma-coreA Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma
569
Schemity
tbsonLocal database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.
Expired Domains MCP | Karma.Domains
karma-domainsConnect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note
Comments