Skip to main content
📖 The AI Tool Bible

Apple Notes MCP vs Postgres MCP Pro

A side-by-side look at pricing, capabilities, pros, cons, and our editorial scores.

 
Apple Notes MCP
MCP Servers
Postgres MCP Pro
MCP Servers
TaglineLet Claude read your local Apple Notes over the Model Context Protocol.Open-source Postgres MCP server with deterministic health checks, index tuning, and safe SQL execution.
CategoryMCP ServersMCP Servers
PricingFree· Free / open-source (MIT). No hosted service; runs locally on your Mac.Free· Free and open source (MIT license). No paid tiers.
ModelModel-agnostic (works with any MCP-capable LLM); optional OpenAI models for experimental LLM-based index tuning
Editorial score
Use cases
Personal knowledge retrieval from Apple NotesSearching decade-old meeting notes during a Claude chatPulling travel or recipe notes into a planning conversationSummarising a specific note by titleBuilding a local MCP toolchain alongside filesystem and browser serversReference implementation for writing your own macOS SQLite-backed MCP server
AI-assisted query optimization in Cursor or Claude DesktopAutomated index recommendations for slow workloadsEXPLAIN plan review with hypothetical indexesProduction database health monitoring via LLM chatDetecting bloated, duplicate, or unused indexesVacuum and transaction-id wraparound risk auditsSafe read-only SQL exploration by AI agentsSchema introspection for LLM SQL generationShared team Postgres MCP endpoint over SSE
Pros
  • Genuinely local: reads the on-disk SQLite database directly, so notes never leave your Mac
  • Trivial install via uv/uvx and a short claude_desktop_config.json block
  • Exposes the three operations that matter most — list, read, search — with a clean MCP surface
  • MIT-licensed Python, small enough to audit or fork in an afternoon
  • Works with any MCP client, not just Claude Desktop, so it composes with other servers
  • No API keys, no subscriptions, no accounts — zero ongoing cost
  • Deterministic index tuning based on the Anytime Algorithm plus hypopg what-if simulation, not LLM guesswork
  • Comprehensive PgHero-derived health checks covering bloat, cache, connections, vacuum, replication, and sequences
  • Restricted mode enforces read-only transactions and blocks COMMIT/ROLLBACK escapes via pglast SQL parsing
  • Works with any MCP client (Claude Desktop, Cursor, Windsurf, Cline, Goose, Qodo Gen) and supports both stdio and SSE transports
  • MIT-licensed and free; installs via Docker, pipx, uvx, or uv with clear per-client config recipes
  • Cost-benefit index selection along the Pareto front with configurable performance-vs-storage threshold
  • Actively maintained by Crystal DBA with Discord community and public roadmap on GitHub
Cons
  • Read-only: cannot create, edit, or append notes from within Claude
  • Skips password-protected notes entirely (ZISPASSWORDPROTECTED is unhandled)
  • No attachment content, no checklist state, no pinned-note filtering, no iCloud sync awareness
  • macOS-only by design, and requires granting Full Disk Access to the runner
  • Repository is archived by the maintainer — bug fixes and new features are unlikely without a fork
  • Search is basic keyword matching against the SQLite text, not semantic retrieval
  • Postgres-only; no MySQL, SQL Server, or other database support
  • Full-featured tuning requires pg_stat_statements and hypopg extensions, which self-managed installs may need to install manually
  • Only two coarse access modes (unrestricted vs restricted) with no per-table or column-level ACLs
  • Credentials are supplied at startup via DATABASE_URI, so switching databases means restarting the server
  • Experimental LLM-based index tuning requires an OpenAI API key and adds external cost/latency
  • Workload compression is basic (query normalization, equal weighting), which can misrank importance in complex workloads
Websitegithub.comgithub.com
Pick Apple Notes MCP if
  • Genuinely local: reads the on-disk SQLite database directly, so notes never leave your Mac
  • Trivial install via uv/uvx and a short claude_desktop_config.json block
  • Exposes the three operations that matter most — list, read, search — with a clean MCP surface
  • MIT-licensed Python, small enough to audit or fork in an afternoon
Pick Postgres MCP Pro if
  • Deterministic index tuning based on the Anytime Algorithm plus hypopg what-if simulation, not LLM guesswork
  • Comprehensive PgHero-derived health checks covering bloat, cache, connections, vacuum, replication, and sequences
  • Restricted mode enforces read-only transactions and blocks COMMIT/ROLLBACK escapes via pglast SQL parsing
  • Works with any MCP client (Claude Desktop, Cursor, Windsurf, Cline, Goose, Qodo Gen) and supports both stdio and SSE transports