{"data":{"slug":"crate-crate","name":"crate","tagline":"Distributed and Scalable SQL Database for Near Real-Time Data Analysis","github_url":"https://github.com/crate/crate","owner":"crate","repo":"crate","owner_avatar_url":"https://avatars.githubusercontent.com/u/4048232?v=4","primary_language":"Java","stars":4424,"forks":608,"topics":["analytics","big-data","cratedb","database","dbms","distributed","distributed-database","distributed-sql-database","elasticsearch","industrial-iot","iot","iot-analytics","iot-database","lucene","olap","postgresql","sql","time-series","tsdb","vector-database"],"archived":false,"github_pushed_at":"2026-08-21T04:01:03+00:00","maintenance_label":"Very active","stars_delta_30d":8,"url":"https://www.graphcanon.com/tools/crate-crate","markdown_url":"https://www.graphcanon.com/tools/crate-crate.md","api_url":"https://www.graphcanon.com/api/graphcanon/tools/crate-crate","graph_url":"https://www.graphcanon.com/api/graphcanon/graph?tool=crate-crate","description":"CrateDB is a distributed and scalable SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.","homepage_url":"https://cratedb.com/database","license":"Apache-2.0","open_issues":331,"watchers":169,"ai_summary":"CrateDB is a PostgreSQL-compatible, distributed SQL database that supports near real-time analytics on massive datasets, suitable for complex queries. Built on Lucene, it's compatible with Elasticsearch and adept at handling time-series data.","readme_excerpt":".. image:: docs/_static/crate-logo.svg\n    :alt: CrateDB\n    :target: https://cratedb.com\n\n----\n\n.. image:: https://github.com/crate/crate/actions/workflows/main.yml/badge.svg\n    :target: https://github.com/crate/crate/actions?query=workflow%3A%22CrateDB+SQL%22\n\n.. image:: https://img.shields.io/badge/docs-latest-brightgreen.svg\n    :target: https://cratedb.com/docs/crate/reference/en/latest/\n\n.. image:: https://img.shields.io/badge/container-docker-green.svg\n    :target: https://hub.docker.com/_/crate/\n\n|\n\n`Help us improve CrateDB by taking our User Survey! <https://cratedb.com/user-survey>`_\n\nAbout\n=====\n\nCrateDB is a distributed SQL database that makes it simple to store and analyze\nmassive amounts of data in real-time.\n\nCrateDB offers the `benefits`_ of an SQL database *and* the scalability and\nflexibility typically associated with NoSQL databases. Modest CrateDB clusters\ncan ingest tens of thousands of records per second without breaking a\nsweat. You can run ad-hoc queries using `standard SQL`_. CrateDB's blazing-fast\ndistributed query execution engine parallelizes query workloads across the\nwhole cluster.\n\nCrateDB is well suited to `containerization`_, can be `scaled horizontally`_\nusing ephemeral virtual machines (e.g., `Kubernetes`_, `AWS`_, and `Azure`_)\nwith `no shared state`_. You can deploy and run CrateDB on any sort of network\n— from personal computers to `multi-region hybrid clouds and the edge`_.\n\n\nFeatures\n========\n\n- Use `standard SQL`_ via the `PostgreSQL wire protocol`_ or an `HTTP API`_.\n\n- Dynamic table schemas and queryable objects provide\n  document-oriented features in addition to the relational features of SQL.\n\n- Support for time-series data, real-time full-text search, geospatial data\n  types and search capabilities.\n\n- Horizontally scalable, highly available and fault-tolerant clusters that run\n  very well in virtualized and containerized environments.\n\n- Extremely fast distributed query execution.\n\n- Auto-partitioning, auto-sharding, and auto-replication.\n\n- Self-healing and auto-rebalancing.\n\n- `User-defined functions`_ (UDFs) can be used to extend the functionality of CrateDB.\n\n\nScreenshots\n===========\n\nCrateDB provides an `Admin UI`_:\n\n.. image:: crate-admin.gif\n    :alt: Screenshots of the CrateDB Admin UI\n\n\nTry CrateDB\n===========\n\nRun CrateDB via the official `Docker Image`_:\n\n.. code-block:: console\n\n    sh$ docker run --publish 4200:4200 --publish 5432:5432 --env CRATE_HEAP_SIZE=1g crate '-Cdiscovery.type=single-node'\n\nOr visit the `installation documentation`_ to see all the available download and\ninstall options.\n\nOnce you're up and running, head over to the `introductory docs`_. To interact\nwith CrateDB, you can use the Admin UI `sql console`_ or the `CrateDB shell`_\nCLI tool. Alternatively, review the list of recommended `clients and tools`_\nthat work with CrateDB.\n\nFor container-specific documentation, check out the `CrateDB on Docker how-to\nguide`_ or the `CrateDB on Kubernetes how-to guide`_.\n\n\nContributing\n============\n\nThis project is primarily maintained by `Crate.io`_, but we welcome community\ncontributions!\n\nSee the `developer docs`_ and the `contribution docs`_ for more information.\n\n\nSecurity\n========\n\nThe CrateDB team and community take security bugs seriously. We appreciate your\nefforts to `responsibly disclose`_ your findings, and will make every effort to\nacknowledge your contributions.\n\nIf you think you discovered a security flaw, please follow the guidelines at\n`SECURITY.md`_.\n\n\nHelp\n====\n\nLooking for more help?\n\n- Try one of our `beginner tutorials`_, `how-to guides`_, or consult the\n  `reference manual`_.\n\n- Check out our `support channels`_.\n\n- `Crate.io`_ also offers `CrateDB Cloud`_, a fully-managed *CrateDB Database\n  as a Service* (DBaaS). The `CrateDB Cloud Tutorials`_ will get you started.\n\n\n.. _Admin UI: https://cratedb.com/docs/crate/admin-ui/\n.. _AWS: https://cratedb.com/docs/crate/tutorials/en/latest/cloud/aws/index.html\n.. _Azure: https://cratedb.com/docs","github_created_at":"2013-04-10T09:17:16+00:00","created_at":"2026-07-07T17:43:56.487538+00:00","updated_at":"2026-08-21T06:02:15.313529+00:00","categories":[{"slug":"data-retrieval","name":"Data & Retrieval","url":"https://www.graphcanon.com/categories/data-retrieval","markdown_url":"https://www.graphcanon.com/categories/data-retrieval.md","api_url":"https://www.graphcanon.com/api/graphcanon/categories/data-retrieval"},{"slug":"vector-databases","name":"Vector Databases","url":"https://www.graphcanon.com/categories/vector-databases","markdown_url":"https://www.graphcanon.com/categories/vector-databases.md","api_url":"https://www.graphcanon.com/api/graphcanon/categories/vector-databases"}],"tags":[{"slug":"analytics","name":"analytics"},{"slug":"big-data","name":"big-data"},{"slug":"cratedb","name":"cratedb"},{"slug":"database","name":"database"},{"slug":"distributed","name":"distributed"},{"slug":"iot-analytics","name":"iot-analytics"},{"slug":"lucene","name":"lucene"},{"slug":"postgresql","name":"postgresql"}],"trust":{"provenance":{"is_fork":false,"github_id":9342529,"owner_type":"Organization","methodology":"github_public_v1","parent_repo":null,"near_duplicate_slugs":[]},"computed_at":"2026-08-21T06:02:14.603Z","maintenance":{"label":"Very active","score":96,"methodology":"github_public_v1","releases_90d":16,"days_since_push":0,"last_release_at":"2026-08-19T12:07:51Z","stars_delta_30d":8,"open_issues_delta_30d":14},"security_summary":{"status":"no_lockfile","scanner":null,"low_count":0,"high_count":0,"last_scan_at":"2026-07-11T11:24:40.866Z","medium_count":0,"scan_profile":"none","critical_count":0}},"capability_facts":{"scan":{"source":"repo_scan","observed_at":"2026-08-21T06:02:15.051Z"},"languages":{"value":["java"],"source":"github.language","observed_at":"2026-08-21T06:02:15.051Z"},"license_spdx":{"value":"Apache-2.0","source":"github.license","observed_at":"2026-08-21T06:02:15.051Z"}},"decision_facts":{"hosting":null,"pricing":null,"requirements":null,"constraints":null,"when_to_use":["- When you require a SQL-compliant database with the flexibility of distributed architecture that can scale horizontally.","- Preferably for use cases involving Big Data analytics where near real-time querying is necessary, such as Industrial IoT or OLAP scenarios."],"when_not_to_use":["- Avoid if your application environment strictly mandates a specific type of database that isn’t PostgreSQL-compliant, and requires custom integrations.","- Not suitable for applications needing absolute transactional guarantees with strict ACID compliance at the expense of performance."],"source":"enrich:decision_facts","observed_at":"2026-07-12T06:34:08.388Z"},"constraint_facets":null,"decision_summary":[{"label":"Adopt for","value":"CrateDB is distinguished by its capability to manage massive data volumes in near real-time with PostgreSQL compatibility and Lucene-based indexing."}]}}