{
  "notice": "bxzxxr MCP archive: a record of what public MCP servers declared when we listed them (we never call their tools). It is data, not a rating: nothing here says a server is safe, secure, verified or trustworthy, and a server can change after we looked. Secrets we detected are redacted; redacted tool lists are withheld and only their hash is shown.",
  "infrastructure": {
    "host": "www.paradedb.com",
    "site": "paradedb.com",
    "addresses": [
      {
        "address": "216.150.16.129",
        "endpoints": 463,
        "shared_infrastructure": true,
        "network": {
          "asn": 16509,
          "name": "AMAZON-02 - Amazon.com, Inc.",
          "prefix": "216.150.16.0/24",
          "country": "US"
        }
      },
      {
        "address": "216.150.1.129",
        "endpoints": 472,
        "shared_infrastructure": true,
        "network": {
          "asn": 16509,
          "name": "AMAZON-02 - Amazon.com, Inc.",
          "prefix": "216.150.1.0/24",
          "country": "US"
        }
      }
    ],
    "addresses_recorded": true,
    "address_history": [
      {
        "addresses": [
          "216.150.16.129",
          "216.150.1.129"
        ],
        "first_seen": "2026-11-22T01:01:00.593Z",
        "last_seen": "2026-11-22T01:01:00.593Z",
        "checks": 1
      }
    ],
    "hosting": [
      {
        "value": "Vercel",
        "evidence": "Server header \"Vercel\""
      }
    ],
    "software": [],
    "server_info": {
      "name": "paradedb",
      "version": "1.1.0",
      "protocol_version": "2025-06-18"
    },
    "headers": {
      "server": "Vercel",
      "strict-transport-security": "max-age=63072000"
    },
    "auth": null
  },
  "related": {
    "same_address": {
      "total": 668,
      "sample": [
        {
          "id": "26",
          "url": "https://mrk.ae/api/mcp",
          "server_name": "ae.mrk/dubai-property",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T04:31:08.438Z"
        },
        {
          "id": "144",
          "url": "https://mcp.agentgates.ai/compute",
          "server_name": "ai.agentgates/compute",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T04:33:02.000Z"
        },
        {
          "id": "300",
          "url": "https://app.augenix.ai/api/mcp/public",
          "server_name": "ai.augenix/build",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T04:38:01.449Z"
        },
        {
          "id": "461",
          "url": "https://callmcp.ai/mcp",
          "server_name": "ai.callmcp/server",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T04:41:01.824Z"
        },
        {
          "id": "465",
          "url": "https://www.canaryusers.ai/api/mcp",
          "server_name": "ai.canaryusers/canaryusers",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T04:41:01.864Z"
        },
        {
          "id": "523",
          "url": "https://agentmart.ciphyr.ai/mcp",
          "server_name": "ai.ciphyr.agentmart/agentmart",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T04:42:02.049Z"
        },
        {
          "id": "524",
          "url": "https://agentmart.ciphyr.ai/mcp/core",
          "server_name": "ai.ciphyr.agentmart/core",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T04:44:00.984Z"
        },
        {
          "id": "540",
          "url": "https://www.clearthesis.ai/mcp",
          "server_name": "ai.clearthesis/clearthesis",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T04:43:00.925Z"
        },
        {
          "id": "670",
          "url": "https://www.decisionlog.ai/api/mcp",
          "server_name": "ai.decisionlog/mcp",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T04:45:03.762Z"
        },
        {
          "id": "906",
          "url": "https://www.frontierdesk.ai/mcp",
          "server_name": "ai.frontierdesk/desk",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T04:52:01.102Z"
        },
        {
          "id": "1078",
          "url": "https://api.gosummer.ai/mcp",
          "server_name": "ai.gosummer/summer",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T04:54:00.852Z"
        },
        {
          "id": "1105",
          "url": "https://guestlogic.ai/mcp",
          "server_name": "ai.guestlogic/guest-logic",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T04:55:02.067Z"
        },
        {
          "id": "1374",
          "url": "https://api.last-price.ai/api/mcp/rpc?profile=lean",
          "server_name": "ai.last-price/pricing",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T05:00:04.106Z"
        },
        {
          "id": "1375",
          "url": "https://api.last-price.ai/api/mcp/rpc",
          "server_name": "ai.last-price/pricing",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T05:02:01.487Z"
        },
        {
          "id": "1480",
          "url": "https://makerportal.ai/api/mcp",
          "server_name": "ai.makerportal/compute",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T05:04:17.776Z"
        },
        {
          "id": "1574",
          "url": "https://www.mosaya.ai/api/mcp",
          "server_name": "ai.mosaya/practice",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T06:43:09.232Z"
        },
        {
          "id": "1616",
          "url": "https://nerdnoir.ai/api/mcp",
          "server_name": "ai.nerdnoir/nerdy",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T06:44:01.679Z"
        },
        {
          "id": "1704",
          "url": "https://opensolid.ai/mcp",
          "server_name": "ai.opensolid/opensolid",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T06:45:02.095Z"
        },
        {
          "id": "1815",
          "url": "https://polargate.ai/api/mcp",
          "server_name": "ai.polargate/polargate",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T06:46:01.165Z"
        },
        {
          "id": "2068",
          "url": "https://satohub.ai/api/mcp",
          "server_name": "ai.satohub/onchain-agents",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T06:48:30.648Z"
        }
      ]
    },
    "same_site": {
      "total": 0,
      "sample": []
    },
    "same_tool_list": {
      "total": 0,
      "sample": []
    },
    "same_publisher": {
      "publisher": "io.github.paradedb",
      "total": 0,
      "sample": []
    },
    "same_repository": {
      "repository_url": "https://github.com/paradedb/website",
      "total": 0,
      "sample": []
    },
    "note": "Shared addresses on big platforms (Cloudflare, Vercel and the like) put unrelated servers together; those are marked shared_infrastructure. A match is a pivot, not a link between operators."
  },
  "endpoint": {
    "id": "58107",
    "server_name": "io.github.paradedb/mcp",
    "url": "https://www.paradedb.com/mcp",
    "host": "www.paradedb.com",
    "transport": "streamable-http",
    "last_checked_at": "2026-11-22T01:01:00.593Z",
    "last_state": "listed",
    "last_detail": null,
    "consecutive_failures": 0,
    "current_sha": "8b9594d3f4015eb3a7fc33226c9376960cbfe82001325e0fbfd264e844e49c12",
    "first_listed_at": "2026-11-22T01:01:00.593Z",
    "created_at": "2026-11-22T01:00:04.137Z",
    "resolved_addresses": [
      "216.150.16.129",
      "216.150.1.129"
    ]
  },
  "server": {
    "name": "io.github.paradedb/mcp",
    "title": "ParadeDB",
    "description": "Search and read ParadeDB documentation, tutorials, and examples.",
    "version": "1.1.0",
    "registry_status": "active",
    "repository_url": "https://github.com/paradedb/website",
    "website_url": "https://www.paradedb.com/",
    "published_at": "2026-11-22T00:57:48.903Z",
    "updated_at": "2026-11-22T00:57:48.903Z",
    "first_seen": "2026-11-22T01:00:03.305Z"
  },
  "other_endpoints": [],
  "intel": {
    "capabilities": [],
    "evm_addresses": [],
    "chains": [],
    "tokens": [],
    "computed_at": "2026-11-22T16:18:19.904Z"
  },
  "operator": {
    "key": "paradedb.com",
    "name": "paradedb.com",
    "platform": false
  },
  "needs_sign_in": false,
  "reachability": {
    "window_days": 30,
    "checks": 1,
    "answered": 1,
    "answered_percent": 100,
    "avg_listing_latency_ms": 456,
    "first_check_in_window": "2026-11-22T01:01:00.593Z",
    "consecutive_failures_now": 0,
    "days": [
      {
        "day": "2026-11-22",
        "checks": 1,
        "answered": 1,
        "last_state": "listed"
      }
    ]
  },
  "tool_list": {
    "sha256": "8b9594d3f4015eb3a7fc33226c9376960cbfe82001325e0fbfd264e844e49c12",
    "tools": 4,
    "resources": 187,
    "prompts": 1,
    "first_seen": "2026-11-22T01:01:01.054Z",
    "tool_names": [
      "search_content",
      "get_page",
      "list_content",
      "get_product_info"
    ],
    "declared": {
      "tools": [
        {
          "name": "search_content",
          "title": "Search ParadeDB content",
          "description": "Search ParadeDB docs and website pages with keywords or a question. Returns titles, URLs, and excerpts. Use get_page to read a page.",
          "inputSchema": {
            "type": "object",
            "$schema": "https://json-schema.org/draft/2020-12/schema",
            "required": [
              "query"
            ],
            "properties": {
              "limit": {
                "type": "integer",
                "maximum": 20,
                "minimum": 1,
                "description": "Max results (default 8)."
              },
              "query": {
                "type": "string",
                "description": "Keywords or a question, e.g. 'BM25 ranking' or 'How do I install ParadeDB with Docker?'."
              },
              "section": {
                "enum": [
                  "docs",
                  "blog",
                  "customers",
                  "learn",
                  "compare",
                  "careers"
                ],
                "type": "string",
                "description": "Filter by section. Use docs for installation, SQL syntax, and deployment."
              }
            }
          },
          "outputSchema": {
            "type": "object",
            "$schema": "https://json-schema.org/draft/2020-12/schema",
            "required": [
              "results"
            ],
            "properties": {
              "results": {
                "type": "array",
                "items": {
                  "type": "object",
                  "required": [
                    "title",
                    "url",
                    "path",
                    "section",
                    "description",
                    "snippet",
                    "score"
                  ],
                  "properties": {
                    "url": {
                      "type": "string"
                    },
                    "date": {
                      "type": "string"
                    },
                    "path": {
                      "type": "string"
                    },
                    "score": {
                      "type": "number"
                    },
                    "title": {
                      "type": "string"
                    },
                    "section": {
                      "type": "string"
                    },
                    "snippet": {
                      "type": "string"
                    },
                    "updated": {
                      "type": "string"
                    },
                    "description": {
                      "type": "string"
                    }
                  },
                  "additionalProperties": false
                }
              }
            },
            "additionalProperties": false
          },
          "annotations": {
            "title": "Search ParadeDB content",
            "readOnlyHint": true,
            "openWorldHint": false,
            "idempotentHint": true,
            "destructiveHint": false
          }
        },
        {
          "name": "get_page",
          "title": "Get a ParadeDB page",
          "description": "Read a page as Markdown by path, URL, or slug. Find pages with search_content or list_content.",
          "inputSchema": {
            "type": "object",
            "$schema": "https://json-schema.org/draft/2020-12/schema",
            "required": [
              "path"
            ],
            "properties": {
              "path": {
                "type": "string",
                "description": "Page path, URL, or slug, e.g. '/docs/start/install' or 'bm25'."
              }
            }
          },
          "annotations": {
            "title": "Get a ParadeDB page",
            "readOnlyHint": true,
            "openWorldHint": false,
            "idempotentHint": true,
            "destructiveHint": false
          }
        },
        {
          "name": "list_content",
          "title": "List ParadeDB content",
          "description": "List docs and website pages with titles and URLs. Optionally filter by section.",
          "inputSchema": {
            "type": "object",
            "$schema": "https://json-schema.org/draft/2020-12/schema",
            "properties": {
              "section": {
                "enum": [
                  "docs",
                  "blog",
                  "customers",
                  "learn",
                  "compare",
                  "careers"
                ],
                "type": "string",
                "description": "Filter by section. Use docs for installation, SQL syntax, and deployment."
              }
            }
          },
          "outputSchema": {
            "type": "object",
            "$schema": "https://json-schema.org/draft/2020-12/schema",
            "required": [
              "items"
            ],
            "properties": {
              "items": {
                "type": "array",
                "items": {
                  "type": "object",
                  "required": [
                    "title",
                    "url",
                    "path",
                    "section",
                    "description"
                  ],
                  "properties": {
                    "url": {
                      "type": "string"
                    },
                    "date": {
                      "type": "string"
                    },
                    "path": {
                      "type": "string"
                    },
                    "title": {
                      "type": "string"
                    },
                    "section": {
                      "type": "string"
                    },
                    "updated": {
                      "type": "string"
                    },
                    "description": {
                      "type": "string"
                    }
                  },
                  "additionalProperties": false
                }
              }
            },
            "additionalProperties": false
          },
          "annotations": {
            "title": "List ParadeDB content",
            "readOnlyHint": true,
            "openWorldHint": false,
            "idempotentHint": true,
            "destructiveHint": false
          }
        },
        {
          "name": "get_product_info",
          "title": "Get ParadeDB product info",
          "description": "Get a structured overview of ParadeDB: what it is, how to install it, and key links (docs, GitHub, blog). Useful for grounding before answering questions.",
          "inputSchema": {
            "type": "object",
            "$schema": "https://json-schema.org/draft/2020-12/schema",
            "properties": {}
          },
          "outputSchema": {
            "type": "object",
            "$schema": "https://json-schema.org/draft/2020-12/schema",
            "required": [
              "name",
              "tagline",
              "description",
              "summary",
              "status",
              "install",
              "connect",
              "links",
              "contentCounts"
            ],
            "properties": {
              "name": {
                "type": "string"
              },
              "links": {
                "type": "object",
                "required": [
                  "website",
                  "docs",
                  "compare",
                  "github",
                  "blog",
                  "llmsTxt",
                  "docsLlmsTxt"
                ],
                "properties": {
                  "blog": {
                    "type": "string"
                  },
                  "docs": {
                    "type": "string"
                  },
                  "github": {
                    "type": "string"
                  },
                  "compare": {
                    "type": "string"
                  },
                  "llmsTxt": {
                    "type": "string"
                  },
                  "website": {
                    "type": "string"
                  },
                  "docsLlmsTxt": {
                    "type": "string"
                  }
                },
                "additionalProperties": false
              },
              "status": {
                "type": "string"
              },
              "connect": {
                "type": "string"
              },
              "install": {
                "type": "string"
              },
              "summary": {
                "type": "string"
              },
              "tagline": {
                "type": "string"
              },
              "description": {
                "type": "string"
              },
              "contentCounts": {
                "type": "object",
                "required": [
                  "docs",
                  "blog",
                  "customers",
                  "learn",
                  "compare",
                  "careers"
                ],
                "properties": {
                  "blog": {
                    "type": "number"
                  },
                  "docs": {
                    "type": "number"
                  },
                  "learn": {
                    "type": "number"
                  },
                  "careers": {
                    "type": "number"
                  },
                  "compare": {
                    "type": "number"
                  },
                  "customers": {
                    "type": "number"
                  }
                },
                "additionalProperties": false
              }
            },
            "additionalProperties": false
          },
          "annotations": {
            "title": "Get ParadeDB product info",
            "readOnlyHint": true,
            "openWorldHint": false,
            "idempotentHint": true,
            "destructiveHint": false
          }
        }
      ],
      "tools_omitted": 0,
      "resources": [
        {
          "name": "Text, Filters, and Now Vectors in One Postgres Index",
          "uri": "paradedb://content/blog/filter-aware-vector-search",
          "mimeType": "text/markdown",
          "description": "We added vectors to the ParadeDB index and tested filtered queries against Turbopuffer and other Postgres vector extensions."
        },
        {
          "name": "SuperScan Migrates from Neon to ParadeDB",
          "uri": "paradedb://content/customers/superscan",
          "mimeType": "text/markdown",
          "description": "How SuperScan migrated from Neon to ParadeDB Cloud after Neon announced the deprecation of pg_search, preserving its Postgres schema and existing queries."
        },
        {
          "name": "Do We Still Have to Denormalize? Have Your Schema and Search It Too",
          "uri": "paradedb://content/blog/joins",
          "mimeType": "text/markdown",
          "description": "How ParadeDB accelerates search and aggregate joins over normalized Postgres schemas using DataFusion, Rank Joins, co-partitioning, and tuple tagging."
        },
        {
          "name": "Making COUNTs and the Rest of Search Really Fast (Part II)",
          "uri": "paradedb://content/blog/opening-a-closed-tin-part-2",
          "mimeType": "text/markdown",
          "description": "How ctid-aware segment partitioning, an inverted DocId map, and bitmap postings accelerated ParadeDB's Wikipedia COUNT queries—then a look at the rest of search, where ParadeDB delivered 10–22x TIN's throughput on filtered and time-sorted Hacker News queries."
        },
        {
          "name": "PlanetScale Released Text Search and We Have a Lot to Say (Part I)",
          "uri": "paradedb://content/blog/opening-a-closed-tin",
          "mimeType": "text/markdown",
          "description": "Two BM25 optimizations and benchmark configuration changes inspired by PlanetScale's TIN benchmarks make ParadeDB's text search faster without changing its document identifiers."
        },
        {
          "name": "Same Query, Three Results: Benchmarking ParadeDB and Postgres FTS",
          "uri": "paradedb://content/blog/benchmarker-iteration",
          "mimeType": "text/markdown",
          "description": "Three benchmark passes over one TopK search query against ParadeDB and Postgres FTS, showing how workload variation and execution shape change the answer."
        },
        {
          "name": "pgvector Limitations",
          "uri": "paradedb://content/learn/postgresql/pgvector-limitations",
          "mimeType": "text/markdown",
          "description": "Understand the practical limits of pgvector: index cost, filtered search performance, missing features, and operational tradeoffs."
        },
        {
          "name": "Tuning pgvector Performance",
          "uri": "paradedb://content/learn/postgresql/tuning-pgvector",
          "mimeType": "text/markdown",
          "description": "Learn how to optimize pgvector performance for efficient vector similarity search in PostgreSQL."
        },
        {
          "name": "What is pgvector?",
          "uri": "paradedb://content/learn/postgresql/what-is-pgvector",
          "mimeType": "text/markdown",
          "description": "Learn about pgvector, the PostgreSQL extension that adds vector data types and similarity search for embeddings and AI workloads."
        },
        {
          "name": "ParadeDB is Officially on Render",
          "uri": "paradedb://content/blog/render",
          "mimeType": "text/markdown",
          "description": "Deploy ParadeDB on Render with one click. Full-text search, vector search, and hybrid search over Postgres — now available on your favorite cloud platform."
        },
        {
          "name": "What We Think About When We Think About Benchmarking",
          "uri": "paradedb://content/blog/what-we-think-about-when-we-think-about-benchmarking",
          "mimeType": "text/markdown",
          "description": "Publishing a benchmark has two hard problems: telling a story worth reading and getting the mechanics right. Here's how we think about both."
        },
        {
          "name": "Cofactr Migrates from MongoDB Atlas to ParadeDB",
          "uri": "paradedb://content/customers/cofactr",
          "mimeType": "text/markdown",
          "description": "How Cofactr replaced MongoDB Atlas Search with ParadeDB to unify its search and primary data stores on Postgres in AWS GovCloud."
        },
        {
          "name": "ParadeDB is Officially on Railway",
          "uri": "paradedb://content/blog/railway",
          "mimeType": "text/markdown",
          "description": "Deploy ParadeDB on Railway with one click. Full-text search, vector search, and hybrid search over Postgres — now available on your favorite cloud platform."
        },
        {
          "name": "A Conversation with Paul Masurel, Creator of Tantivy",
          "uri": "paradedb://content/blog/tantivy-interview",
          "mimeType": "text/markdown",
          "description": "We sat down with Paul Masurel (creator of Tantivy and co-founder of Quickwit) to talk about building a search engine in Rust, following the competitive happy-path with Lucene, open-source maintenance, and the lessons learned along the way."
        },
        {
          "name": "Terrapin Finance Cuts Bond Search Latency by 25x with ParadeDB",
          "uri": "paradedb://content/customers/terrapin-finance",
          "mimeType": "text/markdown",
          "description": "How Terrapin Finance replaced pg_trgm with ParadeDB to power sub-200ms full-text search across 1.1 billion rows of fixed-income data."
        },
        {
          "name": "ParadeDB Powers Modern Treasury's Core UI and Search APIs",
          "uri": "paradedb://content/customers/moderntreasury",
          "mimeType": "text/markdown",
          "description": "How Modern Treasury replaced legacy indexes and roll-up tables with ParadeDB, eliminating query timeouts and increasing write speeds by 2-3x."
        },
        {
          "name": "What is Block WAND?",
          "uri": "paradedb://content/learn/search-concepts/block-wand",
          "mimeType": "text/markdown",
          "description": "Learn about Block-Max WAND, the dynamic pruning algorithm that accelerates top-k document retrieval in search engines."
        },
        {
          "name": "What is pgrx?",
          "uri": "paradedb://content/learn/postgresql/what-is-pgrx",
          "mimeType": "text/markdown",
          "description": "Learn about pgrx, the Rust framework for building PostgreSQL extensions with memory safety and modern tooling."
        },
        {
          "name": "How We Optimized Top K in Postgres",
          "uri": "paradedb://content/blog/optimizing-top-k",
          "mimeType": "text/markdown",
          "description": "How ParadeDB uses principles from search engines to optimize Postgres' Top K performance."
        },
        {
          "name": "Postgres as a Recommender Engine",
          "uri": "paradedb://content/blog/personalized-search-in-postgresql",
          "mimeType": "text/markdown",
          "description": "Build a production-grade personalized search engine entirely within Postgres using BM25 retrieval and vector-based reranking, no external infrastructure required."
        },
        {
          "name": "Postgres as a Search Engine: The Write Performance Problem",
          "uri": "paradedb://content/blog/increased-write-performance",
          "mimeType": "text/markdown",
          "description": "How ParadeDB achieved 10x improved write throughput through searchable buffers, background merging, and handling Postgres HOT chains."
        },
        {
          "name": "Teaching Postgres to Facet Like Elasticsearch",
          "uri": "paradedb://content/blog/faceting",
          "mimeType": "text/markdown",
          "description": "How ParadeDB brings faceted search to PostgreSQL with single-query aggregations, from SQL syntax to planner integration and execution."
        },
        {
          "name": "Deep Dive into ParadeDB's v2 API: The Future of SQL Search",
          "uri": "paradedb://content/blog/v2api",
          "mimeType": "text/markdown",
          "description": "Explore ParadeDB's v2 API that eliminates schema duplication, simplifies tokenization, and provides transparent search operators for intuitive SQL-based full-text search."
        },
        {
          "name": "ParadeDB 0.20.0: Simpler and Faster",
          "uri": "paradedb://content/blog/paradedb-0-20-0",
          "mimeType": "text/markdown",
          "description": "Introducing search aggregation, V2 API as default, and performance improvements that eliminate the complexity between search and analytics in a single Postgres-native system."
        },
        {
          "name": "Hybrid Search in PostgreSQL: The Missing Manual",
          "uri": "paradedb://content/blog/hybrid-search-in-postgresql-the-missing-manual",
          "mimeType": "text/markdown",
          "description": "Build production-ready hybrid search that combines BM25 lexical matching with vector similarity search, all inside PostgreSQL"
        },
        {
          "name": "Introduction to Tantivy",
          "uri": "paradedb://content/learn/tantivy/introduction",
          "mimeType": "text/markdown",
          "description": "Introduction to Tantivy, a fast full-text search engine library written in Rust"
        },
        {
          "name": "From Text to Token: How Tokenization Pipelines Work",
          "uri": "paradedb://content/blog/when-tokenization-becomes-token",
          "mimeType": "text/markdown",
          "description": "Understanding how search engines transform text into tokens through character filtering, tokenization, stemming, and stopword removal."
        },
        {
          "name": "The ACID Test: Why We Think Search Needs Transactions",
          "uri": "paradedb://content/blog/elasticsearch-acid-test",
          "mimeType": "text/markdown",
          "description": "A developer's look at how Elasticsearch and Postgres stack up against the ACID test"
        },
        {
          "name": "Elasticsearch Was Never a Database",
          "uri": "paradedb://content/blog/elasticsearch-was-never-a-database",
          "mimeType": "text/markdown",
          "description": "Elasticsearch is a search engine, not a database. Here's why it falls short as a system of record."
        },
        {
          "name": "Syncing with Postgres: Logical Replication vs. ETL",
          "uri": "paradedb://content/blog/etl-vs-logical-replication",
          "mimeType": "text/markdown",
          "description": "Comparing ETL pipelines with PostgreSQL logical replication for data synchronization."
        },
        {
          "name": "Bilt Reduces Postgres Query Timeouts by 95% with ParadeDB",
          "uri": "paradedb://content/customers/bilt",
          "mimeType": "text/markdown",
          "description": "How Bilt improved their Postgres performance with ParadeDB, reducing query timeouts by 95%."
        },
        {
          "name": "Announcing Our $12M Series A",
          "uri": "paradedb://content/blog/series-a-announcement",
          "mimeType": "text/markdown",
          "description": "Announcing our Series A funding round to accelerate ParadeDB development."
        },
        {
          "name": "We Made Postgres Writes Faster, but it Broke Replication",
          "uri": "paradedb://content/blog/lsm-trees-in-postgres",
          "mimeType": "text/markdown",
          "description": "Exploring LSM tree implementation in PostgreSQL for better write performance."
        },
        {
          "name": "A New Postgres Block Storage Layout for Full Text Search",
          "uri": "paradedb://content/blog/block-storage-part-one",
          "mimeType": "text/markdown",
          "description": "How we implemented a new block storage layout in Postgres for full text search performance."
        },
        {
          "name": "Lexical vs Semantic Search",
          "uri": "paradedb://content/learn/search-concepts/lexical-vs-semantic",
          "mimeType": "text/markdown",
          "description": "Learn the differences between lexical and semantic search methods, when to use each approach, and how hybrid search combines both."
        },
        {
          "name": "What is Faceted Search?",
          "uri": "paradedb://content/learn/search-concepts/faceting",
          "mimeType": "text/markdown",
          "description": "Learn about faceting and faceted search, how they relate to aggregations, and when to use them."
        },
        {
          "name": "What is RAG?",
          "uri": "paradedb://content/learn/search-concepts/retrieval-augmented-generation",
          "mimeType": "text/markdown",
          "description": "Learn about Retrieval-Augmented Generation (RAG) and how it uses search to increase LLM effectiveness."
        },
        {
          "name": "PostgreSQL Full-Text Search: tsvector, GIN, and Ranking",
          "uri": "paradedb://content/learn/search-in-postgresql/full-text-search",
          "mimeType": "text/markdown",
          "description": "Build PostgreSQL full-text search with tsvector, tsquery, GIN indexes, and ts_rank. Follow SQL examples and understand the limits of built-in search."
        },
        {
          "name": "Implementing BM25 in PostgreSQL",
          "uri": "paradedb://content/learn/search-in-postgresql/bm25",
          "mimeType": "text/markdown",
          "description": "Learn how to implement BM25 ranking in PostgreSQL using various approaches from SQL to ParadeDB extensions."
        },
        {
          "name": "What is Full-Text Search?",
          "uri": "paradedb://content/learn/search-concepts/full-text-search",
          "mimeType": "text/markdown",
          "description": "Learn about full-text search capabilities, how they work, and when to use them in your applications."
        },
        {
          "name": "What is Hybrid Search?",
          "uri": "paradedb://content/learn/search-concepts/hybrid-search",
          "mimeType": "text/markdown",
          "description": "Learn about hybrid search systems that combine lexical and semantic search for comprehensive results."
        },
        {
          "name": "Reciprocal Rank Fusion (RRF): Formula and SQL Example",
          "uri": "paradedb://content/learn/search-concepts/reciprocal-rank-fusion",
          "mimeType": "text/markdown",
          "description": "Learn how Reciprocal Rank Fusion combines keyword and vector search rankings, with the RRF formula, a worked example, and PostgreSQL SQL."
        },
        {
          "name": "What is Vector Search?",
          "uri": "paradedb://content/learn/search-concepts/vector-search",
          "mimeType": "text/markdown",
          "description": "Learn about vector search, how it enables semantic similarity matching using high-dimensional embeddings."
        },
        {
          "name": "What is BM25? Formula, Ranking Factors, and Example",
          "uri": "paradedb://content/learn/search-concepts/bm25",
          "mimeType": "text/markdown",
          "description": "Understand the BM25 ranking algorithm, its formula, term frequency, inverse document frequency, and length normalization with a worked example."
        },
        {
          "name": "Alibaba Picks ParadeDB to Bring Full Text Search to its Postgres-Based Data Warehouse",
          "uri": "paradedb://content/customers/alibaba",
          "mimeType": "text/markdown",
          "description": "How Alibaba Cloud integrated ParadeDB for full text search in their Postgres-based data warehouse."
        },
        {
          "name": "INSA Strasbourg Powers New Research Database with ParadeDB",
          "uri": "paradedb://content/customers/insa",
          "mimeType": "text/markdown",
          "description": "How INSA replaced Elasticsearch with ParadeDB for better performance and simplicity."
        },
        {
          "name": "We've Rebranded",
          "uri": "paradedb://content/blog/rebrand",
          "mimeType": "text/markdown",
          "description": "Announcing our rebrand and new visual identity for ParadeDB."
        },
        {
          "name": "Why We Picked AGPL",
          "uri": "paradedb://content/blog/agpl",
          "mimeType": "text/markdown",
          "description": "ParadeDB has been licensed under AGPL from day one. Here's our thought process and case study on why we picked AGPL."
        },
        {
          "name": "Full Text Search over Postgres: Elasticsearch vs. Alternatives",
          "uri": "paradedb://content/blog/elasticsearch-vs-postgres",
          "mimeType": "text/markdown",
          "description": "A comprehensive comparison between Elasticsearch and PostgreSQL for search workloads."
        },
        {
          "name": "Sweetspot Unifies Hybrid Search on Postgres with ParadeDB",
          "uri": "paradedb://content/customers/sweetspot",
          "mimeType": "text/markdown",
          "description": "How SweetSpot leveraged ParadeDB for their search infrastructure."
        },
        {
          "name": "pg_search: Elastic-Quality Full Text Search Inside Postgres",
          "uri": "paradedb://content/blog/introducing-search",
          "mimeType": "text/markdown",
          "description": "Introducing the search capabilities of ParadeDB."
        },
        {
          "name": "Introducing ParadeDB",
          "uri": "paradedb://content/blog/introducing-paradedb",
          "mimeType": "text/markdown",
          "description": "We're excited to announce ParadeDB: a PostgreSQL database optimized for search."
        },
        {
          "name": "Compare ParadeDB",
          "uri": "paradedb://content/compare",
          "mimeType": "text/markdown",
          "description": ""
        },
        {
          "name": "Comparing ParadeDB and Postgres Full-Text Search",
          "uri": "paradedb://content/compare/postgresql",
          "mimeType": "text/markdown",
          "description": "An honest comparison of ParadeDB and Postgres full-text search: how each one ranks, executes Top K, filters, and counts, and where stock FTS stops scaling."
        },
        {
          "name": "Careers at ParadeDB",
          "uri": "paradedb://content/careers",
          "mimeType": "text/markdown",
          "description": "Work at ParadeDB. Explore the team, benefits, and open positions."
        },
        {
          "name": "Database Engineer — Storage & Query Execution",
          "uri": "paradedb://content/careers/database-engineer",
          "mimeType": "text/markdown",
          "description": "Work on Postgres internals, storage, indexing, and query execution in Rust."
        },
        {
          "name": "Platform Engineer — Postgres Platform",
          "uri": "paradedb://content/careers/platform-engineer",
          "mimeType": "text/markdown",
          "description": "Build ParadeDB Cloud, Kubernetes operators, and a Postgres platform at scale."
        },
        {
          "name": "Welcome to ParadeDB",
          "uri": "paradedb://content/docs/start/introduction",
          "mimeType": "text/markdown",
          "description": "Just use Postgres"
        },
        {
          "name": "Install ParadeDB",
          "uri": "paradedb://content/docs/start/install",
          "mimeType": "text/markdown",
          "description": "Run ParadeDB locally"
        },
        {
          "name": "Configure Your Environment",
          "uri": "paradedb://content/docs/start/configure-your-environment",
          "mimeType": "text/markdown",
          "description": "Connect your preferred SQL client or ORM to ParadeDB"
        },
        {
          "name": "Create Your First Index",
          "uri": "paradedb://content/docs/start/create-your-first-index",
          "mimeType": "text/markdown",
          "description": "Create a ParadeDB index over your table"
        },
        {
          "name": "Run Your First Queries",
          "uri": "paradedb://content/docs/start/run-queries",
          "mimeType": "text/markdown",
          "description": "Run your first queries on ParadeDB"
        },
        {
          "name": "Load Your Own Data",
          "uri": "paradedb://content/docs/start/load-data",
          "mimeType": "text/markdown",
          "description": "Dump data from an existing Postgres and load into ParadeDB"
        },
        {
          "name": "Set Up Your Coding Agent",
          "uri": "paradedb://content/docs/start/ai-agents",
          "mimeType": "text/markdown",
          "description": "Teach your coding agent to use ParadeDB"
        },
        {
          "name": "Go to Production",
          "uri": "paradedb://content/docs/start/go-to-production",
          "mimeType": "text/markdown",
          "description": "Move from the sandbox to a production deployment"
        },
        {
          "name": "Reference",
          "uri": "paradedb://content/docs/reference/overview",
          "mimeType": "text/markdown",
          "description": "Detailed syntax for ParadeDB indexes, queries, aggregates, and SQL APIs"
        },
        {
          "name": "Schema Modeling",
          "uri": "paradedb://content/docs/reference/indexing/schema-modeling",
          "mimeType": "text/markdown",
          "description": "Choose between normalized tables and denormalized columns when indexing in ParadeDB"
        },
        {
          "name": "Create an Index",
          "uri": "paradedb://content/docs/reference/indexing/create-index",
          "mimeType": "text/markdown",
          "description": "Index a Postgres table for ParadeDB search workloads"
        },
        {
          "name": "Partial Indexes",
          "uri": "paradedb://content/docs/reference/indexing/indexing-partial",
          "mimeType": "text/markdown",
          "description": "Add row filters to the ParadeDB index"
        },
        {
          "name": "Columnar Storage",
          "uri": "paradedb://content/docs/reference/indexing/columnar",
          "mimeType": "text/markdown",
          "description": "Column-oriented indexing for fast filtering, sorting, and aggregates"
        },
        {
          "name": "Index Partitioning",
          "uri": "paradedb://content/docs/reference/indexing/partition-by",
          "mimeType": "text/markdown",
          "description": "Partition ParadeDB indexes to accelerate filter and JOIN queries"
        },
        {
          "name": "Indexing Expressions",
          "uri": "paradedb://content/docs/reference/indexing/indexing-expressions",
          "mimeType": "text/markdown",
          "description": "Add Postgres expressions to the index"
        },
        {
          "name": "Indexing JSON",
          "uri": "paradedb://content/docs/reference/indexing/indexing-json",
          "mimeType": "text/markdown",
          "description": "Add JSON and JSONB types to the index"
        },
        {
          "name": "Indexing Text Arrays",
          "uri": "paradedb://content/docs/reference/indexing/indexing-arrays",
          "mimeType": "text/markdown",
          "description": "Add text arrays to the index"
        },
        {
          "name": "Indexing 32+ Columns",
          "uri": "paradedb://content/docs/reference/indexing/indexing-composite",
          "mimeType": "text/markdown",
          "description": "Use composite types to index more than 32 columns"
        },
        {
          "name": "Indexing Vectors",
          "uri": "paradedb://content/docs/reference/indexing/indexing-vectors",
          "mimeType": "text/markdown",
          "description": "Vectors live alongside text and filters in the ParadeDB index"
        },
        {
          "name": "Faster BM25 Queries",
          "uri": "paradedb://content/docs/reference/indexing/faster-bm25-queries",
          "mimeType": "text/markdown",
          "description": "Speed up queries that return the most relevant results"
        },
        {
          "name": "Faster Counts",
          "uri": "paradedb://content/docs/reference/indexing/bitmap-postings",
          "mimeType": "text/markdown",
          "description": "Speed up count queries for common search terms"
        },
        {
          "name": "Full-Text / Lexical Search",
          "uri": "paradedb://content/docs/reference/full-text/overview",
          "mimeType": "text/markdown",
          "description": "Full-text query syntax, scoring, filtering, sorting, and highlighting"
        },
        {
          "name": "Tokenizers",
          "uri": "paradedb://content/docs/reference/tokenizers/overview",
          "mimeType": "text/markdown",
          "description": "Tokenizers split large chunks of text into small, searchable units called tokens"
        },
        {
          "name": "Unicode",
          "uri": "paradedb://content/docs/reference/tokenizers/available-tokenizers/unicode",
          "mimeType": "text/markdown",
          "description": "The default text tokenizer in ParadeDB"
        },
        {
          "name": "Literal",
          "uri": "paradedb://content/docs/reference/tokenizers/available-tokenizers/literal",
          "mimeType": "text/markdown",
          "description": "Indexes the text in its raw form, without any splitting or processing"
        },
        {
          "name": "Literal Normalized",
          "uri": "paradedb://content/docs/reference/tokenizers/available-tokenizers/literal-normalized",
          "mimeType": "text/markdown",
          "description": "Like the literal tokenizer, but allows for token filters"
        },
        {
          "name": "Whitespace",
          "uri": "paradedb://content/docs/reference/tokenizers/available-tokenizers/whitespace",
          "mimeType": "text/markdown",
          "description": "Tokenizes text by splitting on whitespace"
        },
        {
          "name": "Ngram",
          "uri": "paradedb://content/docs/reference/tokenizers/available-tokenizers/ngrams",
          "mimeType": "text/markdown",
          "description": "Splits text into small chunks called grams, useful for partial matching"
        },
        {
          "name": "Edge Ngram",
          "uri": "paradedb://content/docs/reference/tokenizers/available-tokenizers/edge-ngrams",
          "mimeType": "text/markdown",
          "description": "Generates prefix n-grams per word, ideal for search-as-you-type"
        },
        {
          "name": "Simple",
          "uri": "paradedb://content/docs/reference/tokenizers/available-tokenizers/simple",
          "mimeType": "text/markdown",
          "description": "Splits on any non-alphanumeric character"
        },
        {
          "name": "Regex Patterns",
          "uri": "paradedb://content/docs/reference/tokenizers/available-tokenizers/regex",
          "mimeType": "text/markdown",
          "description": "Tokenizes text using a regular expression"
        },
        {
          "name": "Chinese Compatible",
          "uri": "paradedb://content/docs/reference/tokenizers/available-tokenizers/chinese-compatible",
          "mimeType": "text/markdown",
          "description": "A simple tokenizer for Chinese, Japanese, and Korean characters"
        },
        {
          "name": "Lindera",
          "uri": "paradedb://content/docs/reference/tokenizers/available-tokenizers/lindera",
          "mimeType": "text/markdown",
          "description": "Uses prebuilt dictionaries to tokenize Chinese, Japanese, and Korean text"
        },
        {
          "name": "ICU",
          "uri": "paradedb://content/docs/reference/tokenizers/available-tokenizers/icu",
          "mimeType": "text/markdown",
          "description": "Splits text according to the Unicode standard"
        },
        {
          "name": "Jieba",
          "uri": "paradedb://content/docs/reference/tokenizers/available-tokenizers/jieba",
          "mimeType": "text/markdown",
          "description": "The most advanced Chinese tokenizer that leverages both a dictionary and statistical models"
        },
        {
          "name": "Source Code",
          "uri": "paradedb://content/docs/reference/tokenizers/available-tokenizers/source-code",
          "mimeType": "text/markdown",
          "description": "Tokenizes text that is actually code"
        },
        {
          "name": "Token Filters",
          "uri": "paradedb://content/docs/reference/token-filters/overview",
          "mimeType": "text/markdown",
          "description": "Configure lowercasing, stemming, ASCII folding, and other token processing"
        },
        {
          "name": "Alpha Numeric Only",
          "uri": "paradedb://content/docs/reference/token-filters/alphanumeric",
          "mimeType": "text/markdown",
          "description": "Removes any tokens that contain characters that are not ASCII letters or digits"
        },
        {
          "name": "ASCII Folding",
          "uri": "paradedb://content/docs/reference/token-filters/ascii-folding",
          "mimeType": "text/markdown",
          "description": "Strips away diacritical marks like accents"
        },
        {
          "name": "Lowercase",
          "uri": "paradedb://content/docs/reference/token-filters/lowercase",
          "mimeType": "text/markdown",
          "description": "Converts all characters to lowercase"
        },
        {
          "name": "Remove Stopwords",
          "uri": "paradedb://content/docs/reference/token-filters/stopwords",
          "mimeType": "text/markdown",
          "description": "Remove language-specific stopwords from the index"
        },
        {
          "name": "Stemmer",
          "uri": "paradedb://content/docs/reference/token-filters/stemming",
          "mimeType": "text/markdown",
          "description": "Reduces words to their root form for a given language"
        },
        {
          "name": "Token Length",
          "uri": "paradedb://content/docs/reference/token-filters/token-length",
          "mimeType": "text/markdown",
          "description": "Remove tokens that are above or below a certain byte length from the index"
        },
        {
          "name": "Trim",
          "uri": "paradedb://content/docs/reference/token-filters/trim",
          "mimeType": "text/markdown",
          "description": "Remove trailing and leading whitespace from a token"
        },
        {
          "name": "Multiple Tokenizers Per Field",
          "uri": "paradedb://content/docs/reference/tokenizers/multiple-per-field",
          "mimeType": "text/markdown",
          "description": "Apply different token configurations to the same field"
        },
        {
          "name": "Query-Time Tokenizer",
          "uri": "paradedb://content/docs/reference/tokenizers/search-tokenizer",
          "mimeType": "text/markdown",
          "description": "Use a different tokenizer at search time than at index time"
        },
        {
          "name": "Synonyms",
          "uri": "paradedb://content/docs/reference/tokenizers/synonyms",
          "mimeType": "text/markdown",
          "description": "Expand search terms with synonym rules you keep in a table, with nothing to reindex when they change"
        },
        {
          "name": "Advanced Query Functions",
          "uri": "paradedb://content/docs/reference/full-text/query-builder",
          "mimeType": "text/markdown",
          "description": "Query builder functions for advanced full-text query types"
        },
        {
          "name": "Match",
          "uri": "paradedb://content/docs/reference/full-text/match",
          "mimeType": "text/markdown",
          "description": "Returns documents that match the provided query string, which is tokenized before matching"
        },
        {
          "name": "Term",
          "uri": "paradedb://content/docs/reference/full-text/term",
          "mimeType": "text/markdown",
          "description": "Look for exact token matches in the source document, without any further processing of the query string"
        },
        {
          "name": "Phrase",
          "uri": "paradedb://content/docs/reference/full-text/phrase",
          "mimeType": "text/markdown",
          "description": "Phrase queries are like match queries, but with order and position of matching tokens enforced"
        },
        {
          "name": "Proximity",
          "uri": "paradedb://content/docs/reference/full-text/proximity",
          "mimeType": "text/markdown",
          "description": "Match documents based on token proximity within the source document"
        },
        {
          "name": "Phrase Prefix",
          "uri": "paradedb://content/docs/reference/full-text/phrase-prefix",
          "mimeType": "text/markdown",
          "description": "Finds documents containing a phrase followed by a term prefix"
        },
        {
          "name": "Regex Phrase",
          "uri": "paradedb://content/docs/reference/full-text/regex-phrase",
          "mimeType": "text/markdown",
          "description": "Matches a specific sequence of regex queries"
        },
        {
          "name": "Fuzzy",
          "uri": "paradedb://content/docs/reference/full-text/fuzzy",
          "mimeType": "text/markdown",
          "description": "Allow for typos in the query string"
        },
        {
          "name": "Regex",
          "uri": "paradedb://content/docs/reference/full-text/regex",
          "mimeType": "text/markdown",
          "description": "Searches for terms that match a regex pattern"
        },
        {
          "name": "Range Term",
          "uri": "paradedb://content/docs/reference/full-text/range-term",
          "mimeType": "text/markdown",
          "description": "Filters over Postgres range types"
        },
        {
          "name": "More Like This",
          "uri": "paradedb://content/docs/reference/full-text/more-like-this",
          "mimeType": "text/markdown",
          "description": "Finds documents that are \"like\" another document"
        },
        {
          "name": "Query Parser",
          "uri": "paradedb://content/docs/reference/full-text/query-parser",
          "mimeType": "text/markdown",
          "description": "Accept raw user-provided query strings"
        },
        {
          "name": "All",
          "uri": "paradedb://content/docs/reference/full-text/all",
          "mimeType": "text/markdown",
          "description": "Search all rows in the index"
        },
        {
          "name": "Overview",
          "uri": "paradedb://content/docs/reference/filtering/overview",
          "mimeType": "text/markdown",
          "description": "Choose the right filtering path for ParadeDB queries"
        },
        {
          "name": "Indexed Columns",
          "uri": "paradedb://content/docs/reference/filtering/indexed",
          "mimeType": "text/markdown",
          "description": "Push filters into the ParadeDB index scan"
        },
        {
          "name": "External Indexes",
          "uri": "paradedb://content/docs/reference/filtering/external-indexes",
          "mimeType": "text/markdown",
          "description": "Combine ParadeDB search with filters backed by other database indexes"
        },
        {
          "name": "Top K",
          "uri": "paradedb://content/docs/reference/full-text/top-k",
          "mimeType": "text/markdown",
          "description": "ParadeDB is optimized for quickly finding the Top K results in a table"
        },
        {
          "name": "BM25 Scoring",
          "uri": "paradedb://content/docs/reference/full-text/score",
          "mimeType": "text/markdown",
          "description": "BM25 scores sort the result set by relevance"
        },
        {
          "name": "Relevance Tuning",
          "uri": "paradedb://content/docs/reference/full-text/relevance-tuning",
          "mimeType": "text/markdown",
          "description": "Tune the BM25 score by adjusting the weights of individual queries"
        },
        {
          "name": "Highlighting",
          "uri": "paradedb://content/docs/reference/full-text/highlight",
          "mimeType": "text/markdown",
          "description": "Generate snippets for portions of the source text that match the query string"
        },
        {
          "name": "Vector / Semantic Search",
          "uri": "paradedb://content/docs/reference/vector/overview",
          "mimeType": "text/markdown",
          "description": "Reference pages for indexing, querying, and tuning vector and semantic search"
        },
        {
          "name": "Querying Vectors",
          "uri": "paradedb://content/docs/reference/vector/querying",
          "mimeType": "text/markdown",
          "description": "Run nearest-neighbor vector search inside the ParadeDB index"
        },
        {
          "name": "Tuning Recall and Latency",
          "uri": "paradedb://content/docs/reference/vector/tuning",
          "mimeType": "text/markdown",
          "description": "Trade recall against latency for vector search"
        },
        {
          "name": "Hybrid Search",
          "uri": "paradedb://content/docs/reference/hybrid/overview",
          "mimeType": "text/markdown",
          "description": "Reference pages for combining full-text and vector rankings"
        },
        {
          "name": "Reciprocal Rank Fusion",
          "uri": "paradedb://content/docs/reference/hybrid/rrf",
          "mimeType": "text/markdown",
          "description": "Combine full text and vector search results into a single ranking"
        },
        {
          "name": "Aggregates",
          "uri": "paradedb://content/docs/reference/aggregates/overview",
          "mimeType": "text/markdown",
          "description": "Accelerate SQL and JSON aggregates with the ParadeDB index"
        },
        {
          "name": "Terms",
          "uri": "paradedb://content/docs/reference/aggregates/bucket/terms",
          "mimeType": "text/markdown",
          "description": "Count the number of occurrences for each value in a result set"
        },
        {
          "name": "Filters",
          "uri": "paradedb://content/docs/reference/aggregates/bucket/filters",
          "mimeType": "text/markdown",
          "description": "Compute aggregations over multiple filters in one query"
        },
        {
          "name": "Histogram",
          "uri": "paradedb://content/docs/reference/aggregates/bucket/histogram",
          "mimeType": "text/markdown",
          "description": "Count the number of occurrences over some interval"
        },
        {
          "name": "Date Histogram",
          "uri": "paradedb://content/docs/reference/aggregates/bucket/datehistogram",
          "mimeType": "text/markdown",
          "description": "Count the number of occurrences over fixed time intervals"
        },
        {
          "name": "Range",
          "uri": "paradedb://content/docs/reference/aggregates/bucket/range",
          "mimeType": "text/markdown",
          "description": "Count the number of occurrences over user-defined buckets"
        },
        {
          "name": "Average",
          "uri": "paradedb://content/docs/reference/aggregates/metrics/average",
          "mimeType": "text/markdown",
          "description": "Compute the average value of a field"
        },
        {
          "name": "Cardinality",
          "uri": "paradedb://content/docs/reference/aggregates/metrics/cardinality",
          "mimeType": "text/markdown",
          "description": "Compute the number of distinct values in a field"
        },
        {
          "name": "Count",
          "uri": "paradedb://content/docs/reference/aggregates/metrics/count",
          "mimeType": "text/markdown",
          "description": "Count matching rows or non-null field values"
        },
        {
          "name": "Min/Max",
          "uri": "paradedb://content/docs/reference/aggregates/metrics/minmax",
          "mimeType": "text/markdown",
          "description": "Compute the min/max value of a field"
        },
        {
          "name": "Percentiles",
          "uri": "paradedb://content/docs/reference/aggregates/metrics/percentiles",
          "mimeType": "text/markdown",
          "description": "Analyze the distribution of a field"
        },
        {
          "name": "Stats",
          "uri": "paradedb://content/docs/reference/aggregates/metrics/stats",
          "mimeType": "text/markdown",
          "description": "Compute several metrics at once"
        },
        {
          "name": "Sum",
          "uri": "paradedb://content/docs/reference/aggregates/metrics/sum",
          "mimeType": "text/markdown",
          "description": "Compute the sum of a field"
        },
        {
          "name": "Top Hits",
          "uri": "paradedb://content/docs/reference/aggregates/metrics/tophits",
          "mimeType": "text/markdown",
          "description": "Compute the top hits for each bucket in a terms aggregation"
        },
        {
          "name": "Facets",
          "uri": "paradedb://content/docs/reference/aggregates/facets",
          "mimeType": "text/markdown",
          "description": "Compute a Top K and aggregate in one query"
        },
        {
          "name": "Limitations",
          "uri": "paradedb://content/docs/reference/aggregates/limitations",
          "mimeType": "text/markdown",
          "description": "Caveats for aggregate support"
        },
        {
          "name": "Supported Join Types",
          "uri": "paradedb://content/docs/reference/joins/overview",
          "mimeType": "text/markdown",
          "description": "JOIN types and pushdown requirements supported by ParadeDB"
        },
        {
          "name": "Using ParadeDB with Citus",
          "uri": "paradedb://content/docs/reference/sharding/citus",
          "mimeType": "text/markdown",
          "description": "Distributed full-text search with Citus and ParadeDB"
        },
        {
          "name": "Operator Reference",
          "uri": "paradedb://content/docs/reference/operators-and-functions",
          "mimeType": "text/markdown",
          "description": "ParadeDB operators and their SQL function equivalents"
        },
        {
          "name": "Configuration Reference",
          "uri": "paradedb://content/docs/reference/configuration",
          "mimeType": "text/markdown",
          "description": "Runtime settings and per-index options for ParadeDB and pg_search"
        },
        {
          "name": "SQL Function Reference",
          "uri": "paradedb://content/docs/reference/sql-functions",
          "mimeType": "text/markdown",
          "description": "User-facing SQL functions exposed by ParadeDB and pg_search"
        },
        {
          "name": "Architecture",
          "uri": "paradedb://content/docs/concepts/architecture",
          "mimeType": "text/markdown",
          "description": "A deep dive into how ParadeDB is built"
        },
        {
          "name": "Guarantees",
          "uri": "paradedb://content/docs/concepts/guarantees",
          "mimeType": "text/markdown",
          "description": "ParadeDB ensures ACID compliance, concurrency, data integrity, and replication safety"
        },
        {
          "name": "How Text Search Works",
          "uri": "paradedb://content/docs/concepts/full-text/overview",
          "mimeType": "text/markdown",
          "description": "Understand how ParadeDB uses token matching to efficiently search large corpuses of text"
        },
        {
          "name": "How Vector Search Works",
          "uri": "paradedb://content/docs/concepts/vector/overview",
          "mimeType": "text/markdown",
          "description": "Understand how ParadeDB natively supports vector search"
        },
        {
          "name": "How Hybrid Search Works",
          "uri": "paradedb://content/docs/concepts/hybrid/overview",
          "mimeType": "text/markdown",
          "description": "Understand how ParadeDB combines text and vector search into a single ranking"
        },
        {
          "name": "Limitations & Tradeoffs",
          "uri": "paradedb://content/docs/concepts/limitations",
          "mimeType": "text/markdown",
          "description": "Understand ParadeDB's key limitations and tradeoffs"
        },
        {
          "name": "ParadeDB Enterprise",
          "uri": "paradedb://content/docs/operate/deploy/enterprise",
          "mimeType": "text/markdown",
          "description": "Feature comparison between ParadeDB Community and Enterprise"
        },
        {
          "name": "Deployment Options",
          "uri": "paradedb://content/docs/operate/deploy/overview",
          "mimeType": "text/markdown",
          "description": "Explore the different ways to deploy ParadeDB into production"
        },
        {
          "name": "ParadeDB Cloud",
          "uri": "paradedb://content/docs/operate/deploy/cloud",
          "mimeType": "text/markdown",
          "description": "Run ParadeDB on our fully managed platform"
        },
        {
          "name": "ParadeDB BYOC",
          "uri": "paradedb://content/docs/operate/deploy/byoc",
          "mimeType": "text/markdown",
          "description": "Run ParadeDB in your cloud, managed by our team"
        },
        {
          "name": "Kubernetes",
          "uri": "paradedb://content/docs/operate/deploy/self-hosted/kubernetes",
          "mimeType": "text/markdown",
          "description": "Run ParadeDB in an existing Kubernetes cluster"
        },
        {
          "name": "Self-Hosted PostgreSQL",
          "uri": "paradedb://content/docs/operate/deploy/self-hosted/extension",
          "mimeType": "text/markdown",
          "description": "Run ParadeDB in a self-managed Postgres cluster"
        },
        {
          "name": "Railway",
          "uri": "paradedb://content/docs/operate/deploy/cloud-platforms/railway",
          "mimeType": "text/markdown",
          "description": "Deploy ParadeDB on Railway"
        },
        {
          "name": "Render",
          "uri": "paradedb://content/docs/operate/deploy/cloud-platforms/render",
          "mimeType": "text/markdown",
          "description": "Deploy ParadeDB on Render"
        },
        {
          "name": "Fly.io",
          "uri": "paradedb://content/docs/operate/deploy/cloud-platforms/fly",
          "mimeType": "text/markdown",
          "description": "Deploy ParadeDB on Fly.io"
        },
        {
          "name": "Dokku",
          "uri": "paradedb://content/docs/operate/deploy/cloud-platforms/dokku",
          "mimeType": "text/markdown",
          "description": "Deploy ParadeDB on Dokku"
        },
        {
          "name": "DigitalOcean",
          "uri": "paradedb://content/docs/operate/deploy/cloud-platforms/digitalocean",
          "mimeType": "text/markdown",
          "description": "Deploy ParadeDB on DigitalOcean"
        },
        {
          "name": "High Availability",
          "uri": "paradedb://content/docs/operate/deploy/self-hosted/high-availability",
          "mimeType": "text/markdown",
          "description": "Use read replicas to minimize downtime in production"
        },
        {
          "name": "Getting Started",
          "uri": "paradedb://content/docs/operate/deploy/logical-replication/getting-started",
          "mimeType": "text/markdown",
          "description": "Configure ParadeDB as a logical subscriber of an existing Postgres primary"
        },
        {
          "name": "Initial Sync and Indexing",
          "uri": "paradedb://content/docs/operate/deploy/logical-replication/bootstrapping",
          "mimeType": "text/markdown",
          "description": "Wait for the initial copy, build ParadeDB indexes, and query replicated data"
        },
        {
          "name": "Replication Configuration",
          "uri": "paradedb://content/docs/operate/deploy/logical-replication/configuration",
          "mimeType": "text/markdown",
          "description": "Configure publication boundaries, replication capacity, and replica identity"
        },
        {
          "name": "Schema Changes",
          "uri": "paradedb://content/docs/operate/deploy/logical-replication/schema-changes",
          "mimeType": "text/markdown",
          "description": "Add replicated tables and safely apply schema changes"
        },
        {
          "name": "Monitoring and Troubleshooting",
          "uri": "paradedb://content/docs/operate/deploy/logical-replication/monitoring-and-troubleshooting",
          "mimeType": "text/markdown",
          "description": "Monitor replication health, resolve apply failures, and recover from WAL buildup"
        },
        {
          "name": "Multi-Database Replication",
          "uri": "paradedb://content/docs/operate/deploy/logical-replication/multi-database",
          "mimeType": "text/markdown",
          "description": "Consolidate multiple microservice databases into a single ParadeDB instance for app-wide search and cross-database joins"
        },
        {
          "name": "Reindexing",
          "uri": "paradedb://content/docs/operate/index-maintenance/reindexing",
          "mimeType": "text/markdown",
          "description": "Rebuild an existing index with zero downtime"
        },
        {
          "name": "Verify Index Integrity",
          "uri": "paradedb://content/docs/operate/index-maintenance/verify-index",
          "mimeType": "text/markdown",
          "description": "Inspect ParadeDB indexes for corruption and structural issues"
        },
        {
          "name": "How to Tune ParadeDB",
          "uri": "paradedb://content/docs/operate/performance-tuning/overview",
          "mimeType": "text/markdown",
          "description": "Tune PostgreSQL settings for better read and write performance"
        },
        {
          "name": "Index Creation",
          "uri": "paradedb://content/docs/operate/performance-tuning/create-index",
          "mimeType": "text/markdown",
          "description": "Settings to make index creation faster"
        },
        {
          "name": "Read Throughput",
          "uri": "paradedb://content/docs/operate/performance-tuning/reads",
          "mimeType": "text/markdown",
          "description": "Settings to improve read performance"
        },
        {
          "name": "Write Throughput",
          "uri": "paradedb://content/docs/operate/performance-tuning/writes",
          "mimeType": "text/markdown",
          "description": "Settings to improve write performance"
        },
        {
          "name": "Upgrading ParadeDB",
          "uri": "paradedb://content/docs/operate/deploy/upgrading",
          "mimeType": "text/markdown",
          "description": "Upgrade ParadeDB to a newer version"
        },
        {
          "name": "GitHub Actions",
          "uri": "paradedb://content/docs/operate/deploy/ci/github-actions",
          "mimeType": "text/markdown",
          "description": "Run ParadeDB in GitHub Actions"
        },
        {
          "name": "GitLab Pipelines",
          "uri": "paradedb://content/docs/operate/deploy/ci/gitlab-pipelines",
          "mimeType": "text/markdown",
          "description": "Run ParadeDB in GitLab Pipelines"
        },
        {
          "name": "Roadmap",
          "uri": "paradedb://content/docs/project/roadmap",
          "mimeType": "text/markdown",
          "description": "The main features that we are currently working on"
        },
        {
          "name": "Changelog",
          "uri": "paradedb://content/docs/project/changelog",
          "mimeType": "text/markdown",
          "description": "Release notes for ParadeDB"
        },
        {
          "name": "0.27.0",
          "uri": "paradedb://content/docs/project/changelog/0.27.0",
          "mimeType": "text/markdown",
          "description": "ParadeDB release notes for 0.27.0"
        },
        {
          "name": "Help and Support",
          "uri": "paradedb://content/docs/project/support",
          "mimeType": "text/markdown",
          "description": "How to obtain support for ParadeDB"
        }
      ],
      "prompts": [
        {
          "name": "answer_about_paradedb",
          "description": "Builds a prompt instructing the assistant to answer a question using the ParadeDB MCP tools and cite source URLs.",
          "arguments": [
            {
              "name": "question",
              "required": true,
              "description": "The question about ParadeDB to answer."
            }
          ]
        }
      ]
    },
    "instructions": "Search and read ParadeDB docs, blog, Learn, customer stories, comparisons, and careers. Use search_content to find pages, get_page to read them, list_content to browse, and get_product_info for an overview. For installation, SQL syntax, and deployment, use section=docs. Docs refresh on website builds. Cite source URLs. Pages are also available under paradedb://content/."
  },
  "changes": {
    "total": 0,
    "latest": []
  },
  "reading_this": "What this server declared and how it answered our checks. Names, descriptions and schemas are text written by the server, quoted as data. Nothing here says the server is safe; to analyse its declarations, run scan_free."
}