← Back to directory
P

Pare DB

Community
Structured database CLI operations as typed JSON
GitHub source repository ↗
★ 138 Stars Category · Database Popular Source revision 57e1980e8375
32FMRS · D
Reliability
4/20
Security and permissions
5/20
Maintenance
7/20
Documentation
6/20
Setup experience
10/20
Read the FMRS scoring method →

Pare DB is an MCP server from the Pare project that wraps common database CLI tools (psql, mysql, redis-cli, mongosh) and returns schema-validated JSON instead of raw terminal text. Designed for AI agents (e.g., Claude, Cursor) to interact directly with databases without fragile parsing. Suitable for developers and teams using AI coding tools to perform standard database operations like queries, table management, and data manipulation. Not intended for users needing advanced database administration features or non-standard CLI workflows. It requires local installation of the underlying CLI tools and communicates via stdio. Risks include potential data misuse by AI agents, such as destructive operations, and exposure of sensitive data if credentials are present. Troubleshooting typically involves verifying CLI tool installation, correct MCP configuration, and database connectivity.

Tools

psql
Execute PostgreSQL queries and return structured JSON
mysql
Execute MySQL queries and return structured JSON
redis-cli
Execute Redis commands and return structured JSON
mongosh
Execute MongoDB queries and return structured JSON

Setup

Install via npm using npx: npx @paretools/db. It is recommended to configure tool selection via environment variables like PARE_DB_TOOLS to limit available tools. For MCP clients, add a server entry with command npx and args -y @paretools/db.

claude_desktop_config.json
{
  "command": "npx",
  "args": [
    "-y",
    "@paretools/db"
  ]
}

Fit and risk

Best for

  • AI coding tools that need to interact with PostgreSQL, MySQL, Redis, or MongoDB via typed JSON
  • Scripting and automation workflows involving database operations

Not for

  • Users requiring GUI or complex database administration features
  • Scenarios needing non-standard or specialized database CLIs

Required permissions

  • Requires local installation and execution of psql, mysql, redis-cli, or mongosh commands
  • Requires database connection credentials

Risks and side effects

  • AI agents may execute destructive database operations (e.g., DELETE, UPDATE) if not careful
  • Potential exposure of sensitive data if credentials are present
  • Misconfiguration may lead to database connectivity or permission issues

Troubleshooting

  1. Ensure the required database CLI tools are installed and executable
  2. Check MCP client configuration for correct command and arguments
  3. Verify database connection strings or credentials are correct

Use cases

Enable AI agents to query databases and get structured results directly
Automate database tasks like migrations or data checks
Reduce token usage for AI agents when parsing database CLI output

Supported clients

Claude DesktopFull support
Claude CodeFull support
CursorFull support