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