← Back to directory
COMPARE UP TO 4 SERVERS

Compare MCP servers

Compare scores, permissions, risks, and fit in one decision-focused table.

Dimensionpg-aiguideAI-optimized PostgreSQL expertise for coding assistantsMCP ClickHouseConnect ClickHouse to your AI assistants
FMRS50 / 100 · D79 / 100 · B
Reliability8 / 2012 / 20
Security and permissions9 / 2018 / 20
Maintenance12 / 2017 / 20
Documentation10 / 2017 / 20
Setup experience11 / 2015 / 20
Best for
  • Developers using AI coding tools (Claude Code, Cursor, Codex, Gemini CLI).
  • Those wanting to ensure generated PostgreSQL code is modern, reliable, and performant.
  • Teams already using ClickHouse who want AI assistants to access data directly.
  • Scenarios requiring fast, read-only data queries and schema exploration.
Not for
  • Applications requiring direct database connections or query execution.
  • Environments needing local, offline operation.
  • Scenarios requiring write access to the database without explicit opt-in.
  • Production environments with stringent security requirements that avoid default permission settings.
Required permissions
  • As a remote HTTP server, it receives queries and returns documentation.
  • As skills, it may be invoked automatically by AI agents.
  • Requires read-only access to ClickHouse database (default).
  • Optional: write access via CLICKHOUSE_ALLOW_WRITE_ACCESS.
  • Optional: destructive operations via CLICKHOUSE_ALLOW_DROP.
Risks and side effects
  • Public server may contain outdated or inaccurate information from docs.
  • Remote server exposed to network risks.
  • AI agents may generate plausible but unvalidated code.
  • If write access is enabled, AI might make unintended modifications.
  • If DROP access is enabled, data deletion could occur accidentally.
  • Credentials may be exposed via environment variables.
Supported clientsClaude Code, Cursor, VS Code, Codex, Gemini CLI, WindsurfClaude Desktop
Tools24