pgmoat
Governed, read-only Postgres access for AI agents: SQL safety, RLS, budgets, tamper-evident audit.
What it does
pgmoat is an MCP server, a connector that lets an AI assistant use it as a tool. It is installed locally as a package and runs on your machine.
From the publisher's description, Electra Index matched it to one capability: sql querying. That makes it a candidate for tasks such as query databases in plain language or build data pipelines.
Facts come from the Official MCP Registry, as declared by the publisher. Capabilities are matched automatically (low confidence). None of this is a test of the tool.
At a glance
How to connect
As declared in the Official MCP Registry · not tested by Electra IndexInstall package
- NPM
pgmoatv0.1.1 · runs locally (stdio)
Required: PGMOAT_DATABASE_URL (get it from the publisher)
MCP settings (Claude Desktop, Cursor and other MCP clients)
{
"mcpServers": {
"pgmoat": {
"command": "npx",
"args": [
"-y",
"pgmoat"
],
"env": {
"PGMOAT_DATABASE_URL": "<your PGMOAT_DATABASE_URL>"
}
}
}
}Replace the values in <angle brackets>.
Tasks it helps with
Share of each task's required capabilities it covers| Query databases in plain language SQL Querying | 50% |
| Build data pipelines SQL Querying | 33% |
Similar tools
Listed for the same task: query databases in plain language- metabase-ai-assistantREMOTELOCALMCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL
- Anomaly AIREMOTELOCALAI data analyst: ask about your Excel, CSV, GA4 or database data and get charts and dashboards back
- Tableau Workbook AuditorREMOTELOCALLocal-only Tableau .twbx audit: lineage, unused fields, duplicate calcs, SQL, version diffs
- HotelinkREMOTELOCALRead-only hotel data (OAuth). Guide: https://mcp.hotelink.ai/llms.txt. Verify with list_datasets
- Vitrus analyticsREMOTELOCALRead-only analytics for all your apps: users, AI traffic, revenue, with the SQL behind every number
- UpCloud MCP by usefulapiREMOTELOCALInspect servers, storage, networks, databases and billing, and start, stop or back up servers
Ready-made AI agents
- $25/mo · free plan
- Wren AI54$179/mo · free plan
- $36/mo · free plan
Facts & evidence
Each fact shows where it was seen and when.| Fact | Value | Evidence | Source | Last confirmed |
|---|---|---|---|---|
| Install package | pgmoat | DECLARED | SRC-001 Official MCP Registry | 6m ago |
| Version | 0.1.1 | DECLARED | SRC-001 Official MCP Registry | 6m ago |
| Package registries | npm | DECLARED | SRC-001 Official MCP Registry | 6m ago |
| Local install (package) | yes | DECLARED | SRC-001 Official MCP Registry | 6m ago |
| Remote access (hosted) | no | DECLARED | SRC-001 Official MCP Registry | 6m ago |
| Repository | https://github.com/Kitalon-Labs-LLC/pgmoat | DECLARED | SRC-001 Official MCP Registry | 6m ago |
| Registry status | active | DECLARED | SRC-001 Official MCP Registry | 6m ago |
| MCP server | yes | DECLARED | SRC-001 Official MCP Registry | 6m ago |
Change history
- NEW25 Oct 2026first seen in the index
Is this page accurate?
Flag it and our robot re-checks the official source. Reports never change a score.Is pgmoat still online?
Free alerts · no accountAre you the publisher of pgmoat?
Free · show your listingAn independent listing builds trust with your buyers. Announce it, and add the badge to your website or README.
<a href="https://electraindex.com/mcp/pgmoat?utm_source=badge&utm_medium=share&utm_campaign=listing"><img src="https://electraindex.com/api/badge/pgmoat" alt="Listed on Electra Index"></a>Questions about pgmoat
How do I connect pgmoat?
Install the npm package pgmoat. The exact settings are in "How to connect" above, as declared in the Official MCP Registry.
Does pgmoat need an API key or token?
Yes. The registry entry lists a required value: PGMOAT_DATABASE_URL. Get it from the publisher.
What can I use pgmoat for?
Based on its description, it is most relevant to: query databases in plain language, build data pipelines.