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
From Binary
From Binary
In Docker
Essential SQL Statements
Use the Built-in SQL Client
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
Cross-Cloud Migration
Follow-the-Workload
Orchestration
JSON Support
Install Client Drivers
Client Connection Parameters
SQL Feature Support
Overview
ADD COLUMN
ADD CONSTRAINT
ALTER COLUMN
ALTER DATABASE
ALTER INDEX
ALTER SEQUENCE
ALTER TABLE
ALTER USER
EXPERIMENTAL_AUDIT
ALTER VIEW
BACKUP (Enterprise)
BEGIN
CANCEL JOB
CANCEL QUERY
COMMIT
CREATE DATABASE
CREATE INDEX
CREATE ROLE (Enterprise)
CREATE SEQUENCE
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
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 SEQUENCE
SHOW CREATE TABLE
SHOW CREATE VIEW
SHOW DATABASES
SHOW EXPERIMENTAL_RANGES
SHOW GRANTS
SHOW INDEX
SHOW JOBS
SHOW QUERIES
SHOW ROLES
SHOW SESSIONS
SHOW SCHEMAS
SHOW TABLES
SHOW TRACE
SHOW USERS
SPLIT AT
TRUNCATE
UPDATE
UPSERT
VALIDATE CONSTRAINT
Functions and Operators
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
Full SQL Grammar
Overview
Check
Default Value
Foreign Key
Not Null
Primary Key
Unique
Overview
ARRAY
BOOL
BYTES
COLLATE
DATE
DECIMAL
FLOAT
INET
INT
INTERVAL
JSONB
SERIAL
STRING
TIME
TIMESTAMP
UUID
Transactions
Views
Window Functions
SQL Best Practices
Indexes
Inverted Indexes
Column Families
Interleaved Tables
Parallel Statement Execution
Information Schema
From PostgreSQL
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
Use Prometheus and Alertmanager
Performance Benchmarking
Performance Tuning
Manage Users
Manage Roles (Enterprise)
Privileges
Overview
Access and Navigate the Admin UI
Overview Dashboard
Runtime Dashboard
SQL Dashboard
Storage Dashboard
Replication Dashboard
Databases Page
Jobs Page
Custom Chart Debug Page
Enterprise Licensing
Start a Node
Initialize a Cluster
Create Security Certificates
Create Security Certificates
Configure Replication Zones
Define Table Partitions (Enterprise)
Enable Node Map (Enterprise)
Cluster Settings
Cockroach Commands
Upgrade to CockroachDB v2.0
Manage Long-Running Queries
Stop a Node
Decommission Nodes
Import Data
Back up Data
Restore Data
Dump/Export Schema or Data
Create a File Server for IMPORT/BACKUP
Rotate Security Certificates
Generate CockroachDB Resources
View Node Details
View Version Details
Diagnostics Reporting
SQL Audit Logging (Experimental)
Overview
Common Errors
Troubleshoot Cluster Setup
Troubleshoot Query Behavior
Understand Debug Logs
Collect Cluster Debug Info
Support Resources
File an Issue
Overview
SQL Layer
Transaction Layer
Distribution Layer
Replication Layer
Storage Layer
Improve the Docs
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
Product FAQs
SQL FAQs
Operational FAQs
CockroachDB in Comparison
Multi-Active Availability
Simplified Deployment
Strong Consistency
SQL
Distributed Transactions
Automated Scaling & Repair
High Availability
Open Source
Go Implementation