Get all the capabilities you expect from a powerful SQL database, wire compatible with PostgreSQL
SQL Playground PostgreSQL compatibility docsQUERY INTROSPECTION TOOLS
Introspect and optimize queries with a strong set of native tools
Command line: Run commands like EXPLAIN and EXPLAIN ANALYZE to understand query plans and performance
ACID transactions
Trust your data is immediately correct at any scale with ACID compliant guarantees and serializable isolation--even with high concurrency and competing distributed transactions
Developer’s guide to transactions Transactions docsOnline schema changes
Make any schema changes while your data is still available for reads and writes, with zero downtime, even in production.
Developer’s guide to schema Online schema changes docsCost-based optimizer
Leverage a first-class query optimizer which analyzes and automatically selects the most optimal query execution plan for best performance in a distributed environment.
Cost-based optimizer docsDeveloper tool integrations
Use your favorite drivers, ORMs, and other third-party developer tools, enabled by CockroachDB’s support for the PostgreSQL wire protocol.
List of tools supportedFree Online Training
Learn the SQL skills you need to scale your database and your resume straight from industry experts.
Getting Started with SQL for App Devs Introduction to Distributed SQL