CrateDB Documentation

Welcome to the official CrateDB Documentation. Whether you are a developer, database administrator, or just starting your journey with CrateDB, our documentation provides the information and knowledge needed to build real-time analytics and hybrid search applications that leverage CrateDB’s unique features.

Benefits

  • In a unified data platform approach, CrateDB includes analyzing relational, JSON, time-series, geospatial, full-text, and vector data within a single system, eliminating the need for multiple databases.

  • The fully distributed SQL query engine, built on top of Apache Lucene, and inheriting technologies from Elasticsearch/OpenSearch, provides performant aggregations and advanced SQL features like JOINs and CTEs on large datasets of semi-structured data.

  • Real-time indexing automatically indexes all columns, including nested structures, as data is ingested, eliminating the need to worry about indexing strategy.

  • The flexible data schema dynamically adapts based on the data you ingest, offering seamless integration and instant readiness for analysis.

  • Columnar storage enables fast search query and aggregation performance.

  • PostgreSQL wire protocol compatibility and a HTTP interface provide versatile integration capabilities.

  • AI-ready: The vector store subsystem integrates well with an extensive 3rd party ecosystem of AI/ML frameworks for advanced data analysis and data-driven decisions.

CrateDB Cloud

Start with a fully managed CrateDB instance to accelerate and simplify working with analytical data. CrateDB Cloud enables seamless deployment, monitoring, backups, and scaling of CrateDB clusters on AWS, Azure or GCPs, eliminating the need for direct database management.

With CrateDB Cloud, you can skip infrastructure setup and focus on delivering value for your business with a query console, SQL Scheduler, table policies and various connectors to import data.

Start forever free cluster with 8 GB of storage

CrateDB Cloud
Database Features

Explore all functional, operational and advanced features of CrateDB at a glance.

Database Features
Database Manual

Learn core CrateDB concepts, including data modeling, querying data, aggregations, sharding, and more.

Database Manual
Client Libraries

Learn how to connect your applications using database drivers, libraries, adapters, and connectors.

CrateDB supports both the HTTP protocol and the PostgreSQL wire protocol, ensuring compatibility with many PostgreSQL clients.

Through corresponding drivers and adapters, CrateDB is compatible with ODBC, JDBC, and other database API specifications.

CrateDB: Client Drivers and Libraries

Learn

Introduction

Learn about the fundamentals of CrateDB, guided and self-guided.

Getting Started

Learn how to interact with the database for the first time.

Getting started with CrateDB

The CrateDB Guide

Guides and tutorials about how to use CrateDB in practice.

The CrateDB Guide

Academy Courses

A learning hub dedicated to data enthusiasts.

The CrateDB Academy

Community Portal

A hangout place for members of the CrateDB community.

The CrateDB Community Portal

Database Clients and Tools

Learn about the fundamental tools and utility programs that support working directly with CrateDB.

Admin UI

Learn about CrateDB’s included web administration interface.

The CrateDB Admin UI
Crash CLI

A command-line interface (CLI) tool for working with CrateDB.

The Crash CLI

Drivers and Integrations

Learn about database client libraries, drivers, adapters, connectors, and integrations with 3rd-party applications and frameworks.

Ecosystem Catalog

Discover integrations and solutions from the open-source community and CrateDB partners.

Ecosystem Catalog
Integration Tutorials I

Learn about the variety of options to connect and integrate with 3rd-party applications.

Integration Tutorials I
Integration Tutorials II

Integration-focused tutorials to help you use CrateDB together with other tools and libraries.

Integration Tutorials II

Examples

Learn how to use CrateDB by digesting concise examples.

CrateDB Examples

A collection of clear and concise examples how to work with CrateDB.

CrateDB Examples
Sample Apps

Different client libraries used by canonical guestbook demo web applications.

CrateDB Sample Apps

Resources: Academy • Blog • Community • Customers • Examples • GitHub • Guide • Support