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.

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

Getting started with CrateDB

The CrateDB Guide

The CrateDB Guide

Academy Courses

The CrateDB Academy

Community Portal

The CrateDB Community Portal

Database Clients and Tools

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

Admin UI

The CrateDB Admin UI
Crash CLI

The Crash CLI

Drivers and Integrations

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

Ecosystem Catalog

Ecosystem Catalog
Integration Tutorials I

Integration Tutorials I
Integration Tutorials II

Integration Tutorials II

Examples

Learn how to use CrateDB by digesting concise examples.

CrateDB Examples

CrateDB Examples
Sample Apps

CrateDB Sample Apps


Resources: AcademyBlogCommunityCustomersExamplesGitHubGuideSupport