Connectivity

CrateDB speaks the PostgreSQL Wire Protocol, making it instantly compatible with a wide ecosystem of SQL clients, BI tools, and programming libraries. You can connect using any PostgreSQL-compatible driver or tool, from psql and DBeaver to Grafana, Superset, or custom applications. This compatibility allows existing teams to reuse their skills, connectors, and integration pipelines without rewriting code.

CrateDB also exposes an HTTP endpoint, allowing developers to execute SQL queries, ingest data, or retrieve results directly over HTTP.  This is ideal for lightweight integrations, web applications, and environments where a traditional database connection isn’t possible. The HTTP API supports JSON-formatted requests and responses, making it easy to integrate CrateDB with APIs, scripts, or data pipelines.

CrateDB provides native drivers and client libraries for popular programming languages and frameworks, including Python, Java, Node.js, Go, and more. These libraries simplify connection setup, authentication, and query execution, giving developers full SQL power with minimal boilerplate. Use standard JDBC or ODBC interfaces, or leverage the CrateDB-specific clients for optimized real-time performance.

CrateDB integrates seamlessly into AI ecosystems through the Model Context Protocol (MCP). This enables AI agents and frameworks to query CrateDB directly, retrieve context in real time, and use live data as part of model prompts or decision-making workflows. The MCP Server makes CrateDB an ideal data foundation for building intelligent applications and autonomous AI systems.

• Universal interoperability: Connect CrateDB with any client, tool, or platform.

• SQL everywhere: Query your data from anywhere,  over standard protocols.

• Developer productivity: Use familiar libraries and frameworks to get started fast.

• AI-ready integration: Feed real-time data directly into AI agents and machine learning pipelines.

• Open ecosystem: No vendor lock-in; just standard, open interfaces.