Prisma MCP vs Read Only Local Postgres MCP Server
A side-by-side look at the Prisma MCP and Read Only Local Postgres MCP Server MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose Prisma MCP for databases work as a local process; choose Read Only Local Postgres MCP Server for databases as a local process. You can also run both side by side in one mcpServers block.
Which MCP server should you choose?
Choose Prisma MCP when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- Its auth model fits you: other.
- You want tools like
CreateBackupTool, CreateConnectionStringTool, CreateRecoveryTool.
Choose Read Only Local Postgres MCP Server when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- You want tools like
connect, disconnect, query.
Feature & specification comparison
Rows where the two servers differ are marked.
| Spec | ||
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 40/100 · Fair | 52/100 · Good |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Local subprocess (stdio) |
| Auth | other | Not declared |
| Pricing | Free | Not declared |
| Required env vars | None listed | None listed |
| Verified owner | Community listing | Community listing |
| GitHub stars | 49 | 2 |
| Directory activity | 6 views 0 installs 0 upvotes | 2 views 0 installs 0 upvotes |
| Tools | 10 | 3 |
| Full listing | View Prisma MCP | View Read Only Local Postgres MCP Server |
Tools & capabilities
Prisma MCP tools 10
CreateBackupToolCreate a new managed Prisma Postgres Backup.CreateConnectionStringToolCreate a new Connection String for a Prisma Postgres database with the given id.CreateRecoveryToolRestore a Prisma Postgres Database to a new database with the given Backup id.DeleteConnectionStringToolDelete a Connection String with the given connection string id.DeleteDatabaseToolDelete a Prisma Postgres database with the given id.ListBackupsToolFetch a list of available Prisma Postgres Backups for the given database id and environment id.ListConnectionStringsToolFetch a list of available Prisma Postgres Database Connection Strings for the given database id and environment id.ListDatabasesToolFetch a list of available Prisma Postgres Databases for user's workspace.ExecuteSqlQueryToolExecute a SQL query on a Prisma Postgres database with the given id.IntrospectSchemaToolIntrospect the schema of a Prisma Postgres database with the given id.
Read Only Local Postgres MCP Server tools 3
connectConnect to a PostgreSQL database using a connection string. The connection persists for subsequent queries until changed or disconnected. The target must be `DB_HOST:DB_PORT` or listed in `DB_ALLOWED_HOSTS`.disconnectDisconnect from the current runtime database and revert to the default environment-configured connection.queryRun a read-only SQL query against the currently connected database. Optionally override the connection for a single query.
Ready-to-paste client configs
Paste either block (or both) into your client config, e.g. claude_desktop_config.json or ~/.cursor/mcp.json. We only show a config when the install command is confirmed.
Prisma MCP
{
"mcpServers": {
"prisma-mcp": {
"command": "npx",
"args": [
"-y",
"mcp-remote"
]
}
}
}
Read Only Local Postgres MCP Server
{
"mcpServers": {
"read-only-local-postgres-mcp-server": {
"command": "npx",
"args": [
"-y",
"@hovecapital/read-only-postgres-mcp-server"
]
}
}
}
Frequently asked questions
Prisma MCP is categorized under Databases and uses a local stdio subprocess. Read Only Local Postgres MCP Server belongs to Databases and uses a local stdio subprocess. Pick Prisma MCP for databases work and Read Only Local Postgres MCP Server for databases.
Copy the mcpServers block from the config section on this page into your client's config (for example claude_desktop_config.json or ~/.cursor/mcp.json), then fully restart the client.
Prisma MCP is listed as free. Auth: other. Read Only Local Postgres MCP Server has no declared pricing — check the project's own site. If a server needs environment variables such as API keys, define them under the env key in your client's MCP config.
Yes. MCP clients support multiple servers: add prisma-mcp and read-only-local-postgres-mcp-server as separate keys in the same mcpServers object, and your assistant will call tools from either one.
On AllMCPs, Prisma MCP has a quality signal of 40/100 (Fair) with 6 views, 0 installs and 49 GitHub stars. Read Only Local Postgres MCP Server has 52/100 (Good) with 2 views, 0 installs and 2 GitHub stars.