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 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 Authentication Encryption Authorization SQL Audit Logging GSSAPI Authentication Overview Use the Admin UI Enable the Node Map Use Prometheus and Alertmanager Configure Replication Zones Performance Benchmarking Performance Tuning Performance Tuning Table Partitioning Change Data Capture Enterprise Features Migration Overview Migrate from Oracle Migrate from Postgres Migrate from MySQL Migrate from CSV Upgrade to CockroachDB v19.1 Online Schema Changes 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 Geo-Partitioning Data Replication Fault Tolerance & Recovery Automatic Rebalancing Serializable Transactions Cross-Cloud Migration Follow-the-Workload Orchestration with Kubernetes JSON Support Overview SQL Layer Transaction Layer Distribution Layer Replication Layer Storage Layer Life of a Distributed Transaction Reads and Writes Overview 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 COMMENT ON COMMIT CONFIGURE ZONE CREATE CHANGEFEED (Enterprise) CREATE DATABASE CREATE INDEX CREATE ROLE (Enterprise) CREATE SEQUENCE CREATE STATISTICS 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 EXPERIMENTAL CHANGEFEED FOR EXPLAIN EXPLAIN ANALYZE EXPORT (Enterprise) GRANT <privileges> GRANT <roles> IMPORT 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 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 SEQUENCES SHOW SESSIONS SHOW STATISTICS SHOW TABLES SHOW TRACE FOR SESSION SHOW USERS SHOW ZONE CONFIGURATIONS SPLIT AT TRUNCATE 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 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 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 ballast cockroach debug encryption-active-key cockroach debug merge-logs cockroach debug zip 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 Databases Page Statements Page Jobs Page Advanced Debugging Page Custom Chart Debug Page Overview DBeaver IntelliJ IDEA Diagnostics Reporting 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