Docs Home Quickstart CockroachDB Cloud Create an Account Create a CockroachDB Cloud Cluster Create a CockroachDB Cloud Cluster Connect to Your Cluster Connect to Your Cluster Learn CockroachDB SQL Use the Cloud API Manage Your Cluster Manage Your Cluster Security Overview Authentication Overview Single Sign-On (SSO) Configure Cloud Organization SSO Access Management Overview and FAQ Managing Access in CockroachDB Cloud Network Authorization Create Private Clusters Egress Perimeter Controls (Preview) SQL Audit Logging Export Cloud Organization Audit Logs Migration Overview Migrate from Oracle Migrate from PostgreSQL Migrate from MySQL Migrate from CSV Migrate from Avro Import Performance Best Practices Tune Performance Move into Production Cluster Overview Page Alerts Page Tools Page Statements Page Sessions Page Transactions Page Databases Page Troubleshoot Your Cluster Take and Restore Customer-Owned Backups Use Managed-Service Backups Upgrade Policy Upgrade a cluster Manage Billing Deploy a Python To-Do App with Flask, Kubernetes, and CockroachDB Cloud Stream a Changefeed to Snowflake Cloud Release Notes Install CockroachDB Install CockroachDB Install CockroachDB Install CockroachDB From Binary From Binary In Kubernetes In Kubernetes In Docker Learn CockroachDB SQL Overview Go Go Python Python Ruby Ruby Java Java Node.js Node.js C++ C# (.NET) Clojure PHP Rust Data Replication Fault Tolerance & Recovery Automatic Rebalancing Serializable Transactions Cross-Cloud Migration Follow-the-Workload Orchestration with Kubernetes JSON Support Production Checklist Overview On-Premises On-Premises AWS AWS Azure Azure Digital Ocean Digital Ocean Google Cloud Platform GCE Google Cloud Platform GCE Overview Kubernetes Single-Cluster Deployment Kubernetes Single-Cluster Deployment Kubernetes Multi-Cluster Deployment Kubernetes Performance Optimization Docker Swarm Deployment Docker Swarm Deployment Overview Authentication Encryption Authorization SQL Audit Logging Overview Use the Admin UI Use Prometheus and Alertmanager Configure Replication Zones Performance Benchmarking Performance Tuning Performance Tuning Request an Enterprise License Table Partitioning Node Map Change Data Capture Migration Overview Migrate from Postgres Migrate from MySQL Migrate from CSV Upgrade to CockroachDB v2.1 Manage Long-Running Queries Decommission Nodes Back up and Restore Data Create a File Server for IMPORT/BACKUP Rotate Security Certificates Overview Common Errors Troubleshoot Cluster Setup Troubleshoot Query Behavior Understand Debug Logs Support Resources File an Issue Improve the Docs Supported Client Drivers Client Connection Parameters SQL Best Practices SQL Feature Support Overview ADD COLUMN ADD CONSTRAINT ALTER COLUMN ALTER DATABASE ALTER INDEX ALTER RANGE ALTER SEQUENCE ALTER TABLE ALTER TYPE ALTER USER EXPERIMENTAL_AUDIT ALTER VIEW BACKUP (Enterprise) BEGIN CANCEL JOB CANCEL QUERY CANCEL SESSION COMMIT CONFIGURE ZONE CREATE CHANGEFEED (Enterprise) CREATE DATABASE CREATE INDEX CREATE ROLE (Enterprise) CREATE SEQUENCE CREATE STATISTICS (Experimental) CREATE TABLE CREATE TABLE AS CREATE USER CREATE VIEW DELETE DROP COLUMN DROP CONSTRAINT DROP DATABASE DROP INDEX DROP ROLE (Enterprise) DROP SEQUENCE DROP TABLE DROP USER DROP VIEW EXPLAIN EXPLAIN ANALYZE EXPORT (Enterprise) GRANT <privileges> GRANT <roles> (Enterprise) IMPORT INSERT PARTITION BY (Enterprise) PAUSE JOB RENAME COLUMN RENAME DATABASE RENAME INDEX RENAME TABLE RENAME SEQUENCE RELEASE SAVEPOINT RESET <session variable> RESET CLUSTER SETTING RESTORE (Enterprise) RESUME JOB REVOKE <privileges> REVOKE <roles> (Enterprise) ROLLBACK SAVEPOINT SELECT SET <session variable> SET CLUSTER SETTING SET TRANSACTION SHOW <session variables> SHOW BACKUP SHOW CLUSTER SETTING SHOW COLUMNS SHOW CONSTRAINTS SHOW CREATE SHOW DATABASES SHOW EXPERIMENTAL_RANGES SHOW GRANTS SHOW INDEX SHOW JOBS SHOW QUERIES SHOW ROLES SHOW SCHEMAS SHOW SESSIONS SHOW STATISTICS (Experimental) SHOW TABLES SHOW TRACE FOR SESSION SHOW USERS SHOW ZONE CONFIGURATIONS SPLIT AT TRUNCATE UPDATE UPSERT VALIDATE CONSTRAINT Overview ARRAY BOOL BYTES COLLATE DATE DECIMAL FLOAT INET INT INTERVAL JSONB SERIAL STRING TIME TIMESTAMP UUID Overview Check Default Value Foreign Key Not Null Primary Key Unique Functions and Operators Full SQL Grammar Keywords & Identifiers Constants Selection Queries Ordering Query Results Limiting Query Results Table Expressions Common Table Expressions Join Expressions Computed Columns Scalar Expressions Subqueries Name Resolution AS OF SYSTEM TIME NULL Handling Transactions Views Window Functions Indexes Inverted Indexes Column Families Interleaved Tables Parallel Statement Execution Cost-Based Optimizer Information Schema From PostgreSQL Experimental Features Overview cockroach start cockroach init cockroach cert cockroach quit cockroach sql cockroach sqlfmt cockroach user cockroach node cockroach dump cockroach demo cockroach debug zip cockroach gen cockroach version cockroach workload Cluster Settings Overview Cost-Based Optimizer Admin UI Overview Cluster Overview Page Overview Dashboard Hardware Dashboard Runtime Dashboard SQL Dashboard Storage Dashboard Replication Dashboard Databases Page Statements Page Jobs Page Advanced Debugging Page Custom Chart Debug Page Overview DBeaver IntelliJ IDEA Diagnostics Reporting Overview SQL Layer Transaction Layer Distribution Layer Replication Layer Storage Layer Life of a Distributed Transaction Reads and Writes Overview Multi-Active Availability Simplified Deployment Strong Consistency SQL Distributed Transactions Online Schema Changes Automated Scaling & Repair High Availability Open Source Go Implementation Product FAQs SQL FAQs Operational FAQs CockroachDB in Comparison Latest Production Release All Releases v25.1 v24.3 v24.2 v24.1 Release Support Policy Known Limitations CockroachDB Cloud CockroachDB Kubernetes Operator Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Technical Advisories Unsupported Versions