RRepoGEO

REPOGEO REPORT · LITE

crystaldba/postgres-mcp

Default branch main · commit 07eb329c · scanned 5/27/2026, 11:02:22 AM

GitHub: 2,809 stars · 311 forks

AI VISIBILITY SCORE
35 /100
Critical
Category recall
0 / 2
Not recommended in any query
Rule findings
1 pass · 1 warn · 0 fail
Objective metadata checks
AI knows your name
3 / 3
Direct prompts that named your repo
HOW TO READ THIS REPORT

Action plan is what to do next — copy-pasteable changes prioritized by impact. Category visibility is the real GEO test: when a user asks an AI a brand-free question that should surface crystaldba/postgres-mcp, does the AI actually recommend you — or your competitors? Objective checks verify the metadata signals AI engines weight first. Self-mention check detects whether AI even knows you exist by name.

Action plan — copy-paste fixes

2 prioritized changes generated by gemini-2.5-flash. Mark items done after you ship the fix.

OVERALL DIRECTION
  • highreadme#1
    Update README main heading to emphasize AI-readiness

    Why:

    CURRENT
    <h3>A Postgres MCP server with index tuning, explain plans, health checks, and safe sql execution.</h3>
    COPY-PASTE FIX
    <h1>Postgres MCP Pro: An AI-Ready Server for PostgreSQL Performance, Health, and Safe SQL Execution</h1>
  • mediumhomepage#2
    Add a homepage URL to the repository metadata

    Why:

    COPY-PASTE FIX
    https://pypi.org/project/postgres-mcp/

Category GEO backends resolved for this scan: google/gemini-2.5-flash, deepseek/deepseek-v4-flash

Category visibility — the real GEO test

Brand-free queries asked to google/gemini-2.5-flash. Did AI recommend you, or someone else?

Same questions for every model — switch tabs to compare answers and rankings.

Recall
0 / 2
0% of queries surface crystaldba/postgres-mcp
Avg rank
—
Lower is better. #1 = top recommendation.
Share of voice
0%
Of all named tools, what % are you?
Top rival
psycopg/psycopg2
Recommended in 2 of 2 queries
COMPETITOR LEADERBOARD
  1. psycopg/psycopg2 · recommended 2×
  2. citusdata/pg_auto_failover · recommended 1×
  3. pg_stat_statements · recommended 1×
  4. dalibo/pgbadger · recommended 1×
  5. percona/pmm · recommended 1×
  • CATEGORY QUERY
    How can I automate PostgreSQL performance analysis, health checks, and index tuning?
    you: not recommended
    AI recommended (in order):
    1. pg_auto_failover (citusdata/pg_auto_failover)
    2. pg_stat_statements
    3. pgBadger (dalibo/pgbadger)
    4. PMM (percona/pmm)
    5. Datadog
    6. New Relic
    7. Dynatrace
    8. pgTune (pgtune/pgtune)
    9. EXPLAIN ANALYZE
    10. Python
    11. psycopg2 (psycopg/psycopg2)

    AI recommended 11 alternatives but never named crystaldba/postgres-mcp. This is the gap to close.

    Show full AI answer
  • CATEGORY QUERY
    What tools offer safe and configurable SQL access for PostgreSQL, especially for AI-driven operations?
    you: not recommended
    AI recommended (in order):
    1. Hasura (hasura/graphql-engine)
    2. PostgREST (PostgREST/postgrest)
    3. Supabase (supabase/supabase)
    4. pg-promise (vitaly-t/pg-promise)
    5. SQLAlchemy (sqlalchemy/sqlalchemy)
    6. Prisma (prisma/prisma)
    7. psycopg2 (psycopg/psycopg2)
    8. node-postgres (brianc/node-postgres)
    9. go-pg (go-pg/pg)

    AI recommended 9 alternatives but never named crystaldba/postgres-mcp. This is the gap to close.

    Show full AI answer

Objective checks

Rule-based audits of metadata signals AI engines weight most.

  • Metadata completeness
    warn

    Suggestion:

  • README presence
    pass

Self-mention check

Does AI even know your repo exists when asked about it directly?

  • Compared to common alternatives in this category, what is the core differentiator of crystaldba/postgres-mcp?
    pass
    AI named crystaldba/postgres-mcp explicitly

    AI answers can be confidently wrong. Read for accuracy: does it match your actual tech stack, audience, and differentiator?

  • If a team adopts crystaldba/postgres-mcp in production, what risks or prerequisites should they evaluate first?
    pass
    AI named crystaldba/postgres-mcp explicitly

    AI answers can be confidently wrong. Read for accuracy: does it match your actual tech stack, audience, and differentiator?

  • In one sentence, what problem does the repo crystaldba/postgres-mcp solve, and who is the primary audience?
    pass
    AI named crystaldba/postgres-mcp explicitly

    AI answers can be confidently wrong. Read for accuracy: does it match your actual tech stack, audience, and differentiator?

Embed your GEO score

Drop this badge into the README of crystaldba/postgres-mcp. It auto-updates whenever the report is rescanned and links back to the latest report — easy public proof that you care about AI discoverability.

RepoGEO badge previewLive preview
MARKDOWN (README)
[![RepoGEO](https://repogeo.com/badge/crystaldba/postgres-mcp.svg)](https://repogeo.com/en/r/crystaldba/postgres-mcp)
HTML
<a href="https://repogeo.com/en/r/crystaldba/postgres-mcp"><img src="https://repogeo.com/badge/crystaldba/postgres-mcp.svg" alt="RepoGEO" /></a>
Pro

Subscribe to Pro for deep diagnoses

crystaldba/postgres-mcp — Lite scans stay free; this card itemizes Pro deep limits vs Lite.

  • Deep reports10 / month
  • Brand-free category queries5 vs 2 in Lite
  • Prioritized action items8 vs 3 in Lite