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 CockroachDB Install CockroachDB Install CockroachDB Install CockroachDB Install CockroachDB From Binary From Binary In Kubernetes In Kubernetes In Docker In Docker In Docker Learn CockroachDB SQL Replication & Rebalancing Fault Tolerance & Recovery Multi-Region Topologies Serializable Transactions Cross-Cloud Migration Orchestration with Kubernetes JSON Support SQL Tuning with EXPLAIN Overview Install a Postgres Client Connect to the Database Insert Data Query Data Update Data Delete Data Run Multi-Statement Transactions Error Handling & Troubleshooting Make Queries Fast Overview Go Go Go Go Python Python Python Ruby Ruby Java Java Java Node.js Node.js C++ C# (.NET) Clojure PHP Rust Spring Boot with JDBC Spring Boot with JPA Overview Use-Case Database Schema Setup Application Deployment Third-Party Database Tools DBeaver GUI Flyway Schema Migrations IntelliJ IDEA Production Checklist Overview Development Basic Production Geo-Partitioned Replicas Geo-Partitioned Leaseholders Duplicate Indexes Follower Reads Follow-the-Workload 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 Benchmarking Instructions Benchmarking Instructions Benchmarking Instructions Benchmarking Instructions Tuning Best Practices Tuning Tutorial Tuning Tutorial Overview Authentication Encryption Authorization SQL Audit Logging GSSAPI Authentication Overview Enable the Node Map Use Prometheus and Alertmanager Upgrade to CockroachDB v20.1 Online Schema Changes Manage Long-Running Queries Decommission Nodes Overview Advanced Options Create a File Server for IMPORT/BACKUP Rotate Security Certificates Disaster Recovery Replication Controls Overview Table Partitioning Change Data Capture Migration Overview Migrate from Oracle Migrate from Postgres Migrate from MySQL Migrate from CSV Migrate from Avro Import Performance Best Practices Overview Common Errors Troubleshoot Cluster Setup Troubleshoot Query Behavior Understand Debug Logs Replication Reports Support Resources File an Issue Overview SQL Layer Transaction Layer Distribution Layer Replication Layer Storage Layer Life of a Distributed Transaction Reads and Writes Overview PostgreSQL Compatibility Client Connection Parameters SQL Best Practices SQL Feature Support Overview ADD COLUMN ADD CONSTRAINT ALTER COLUMN ALTER DATABASE ALTER INDEX ALTER PARTITION (Enterprise) ALTER PRIMARY KEY ALTER RANGE ALTER ROLE ALTER SEQUENCE ALTER TABLE ALTER USER EXPERIMENTAL_AUDIT ALTER VIEW BACKUP (Enterprise) BEGIN CANCEL JOB CANCEL QUERY CANCEL SESSION COMMENT ON COMMIT CONFIGURE ZONE CREATE CHANGEFEED (Enterprise) CREATE DATABASE CREATE INDEX CREATE ROLE CREATE SEQUENCE CREATE STATISTICS CREATE TABLE CREATE TABLE AS CREATE USER CREATE VIEW DELETE DROP COLUMN DROP CONSTRAINT DROP DATABASE DROP INDEX DROP ROLE DROP SEQUENCE DROP TABLE DROP USER DROP VIEW EXPERIMENTAL CHANGEFEED FOR EXPLAIN EXPLAIN ANALYZE EXPORT (Enterprise) GRANT <privileges> GRANT <roles> IMPORT IMPORT INTO INSERT PARTITION BY (Enterprise) PAUSE JOB RENAME COLUMN RENAME CONSTRAINT RENAME DATABASE RENAME INDEX RENAME TABLE RENAME SEQUENCE RELEASE SAVEPOINT RESET <session variable> RESET CLUSTER SETTING RESTORE (Enterprise) RESUME JOB REVOKE <privileges> REVOKE <roles> ROLLBACK SAVEPOINT SELECT SELECT FOR UPDATE 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 GRANTS SHOW INDEX SHOW JOBS SHOW LOCALITY SHOW PARTITIONS (Enterprise) SHOW QUERIES SHOW RANGES SHOW RANGE FOR ROW SHOW ROLES SHOW SCHEMAS SHOW SEQUENCES SHOW SESSIONS SHOW STATISTICS SHOW SAVEPOINT STATUS SHOW TABLES SHOW TRACE FOR SESSION SHOW USERS SHOW ZONE CONFIGURATIONS SPLIT AT TRUNCATE UNSPLIT AT UPDATE UPSERT VALIDATE CONSTRAINT Overview ARRAY BIT 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 Temporary Tables Name Resolution AS OF SYSTEM TIME NULL Handling Overview Advanced Client-side Transaction Retries Views Window Functions SQL Best Practices Indexes Inverted Indexes Column Families Interleaved Tables Cost-Based Optimizer Vectorized Execution Information Schema Experimental Features Overview cockroach start cockroach init cockroach start-single-node cockroach cert cockroach quit cockroach sql cockroach sqlfmt cockroach node cockroach nodelocal upload cockroach auth-session cockroach dump cockroach demo cockroach debug ballast cockroach debug encryption-active-key cockroach debug merge-logs cockroach debug zip cockroach statement-diag cockroach gen cockroach version cockroach workload Cluster Settings Overview Cost-Based Optimizer Follower Reads Load-Based Splitting Range Merges Admin UI Overview Cluster Overview Page Overview Dashboard Hardware Dashboard Runtime Dashboard SQL Dashboard Storage Dashboard Replication Dashboard Changefeeds Dashboard Custom Chart Databases Page Statements Page Network Latency Page Jobs Page Advanced Debug Page Third-Party Database Tools Diagnostics Reporting MovR: Vehicle-Sharing App Product FAQs SQL FAQs Operational FAQs Availability FAQs Licensing 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