By Industry
By Use Case
Docs hub
Access tutorial, guides, example application, and much more
All Customer stories
Industry leaders trust CockroachDB to run their most data-intensive, mission-critical applications.
Featured stories
ccloud
AS OF SYSTEM TIME
EXPLAIN
ALTER BACKUP
ALTER BACKUP SCHEDULE
ALTER CHANGEFEED
ALTER DATABASE
ALTER DEFAULT PRIVILEGES
ALTER FUNCTION
ALTER INDEX
ALTER PARTITION
ALTER PROCEDURE
ALTER RANGE
ALTER ROLE
ALTER SCHEMA
ALTER SEQUENCE
ALTER TABLE
ALTER TYPE
ALTER USER
ALTER VIEW
ALTER VIRTUAL CLUSTER
BACKUP
BEGIN
CALL
CANCEL JOB
CANCEL QUERY
CANCEL SESSION
COMMENT ON
COMMIT
COPY
CREATE CHANGEFEED
CREATE DATABASE
CREATE EXTERNAL CONNECTION
CREATE FUNCTION
CREATE INDEX
CREATE PROCEDURE
CREATE ROLE
CREATE SCHEDULE FOR BACKUP
CREATE SCHEDULE FOR CHANGEFEED
CREATE SCHEMA
CREATE SEQUENCE
CREATE STATISTICS
CREATE TABLE
CREATE TABLE AS
CREATE TYPE
CREATE USER
CREATE VIEW
CREATE VIRTUAL CLUSTER
DELETE
DROP DATABASE
DROP EXTERNAL CONNECTION
DROP FUNCTION
DROP OWNED BY
DROP TYPE
DROP INDEX
DROP PROCEDURE
DROP ROLE
DROP SCHEDULES
DROP SCHEMA
DROP SEQUENCE
DROP TABLE
DROP USER
DROP VIEW
DROP VIRTUAL CLUSTER
EXPERIMENTAL CHANGEFEED FOR
EXPLAIN ANALYZE
EXPORT
GRANT
IMPORT
IMPORT INTO
INSERT
JOIN
LIMIT
OFFSET
ORDER BY
PAUSE JOB
PAUSE SCHEDULES
REASSIGN OWNED
REFRESH
RELEASE SAVEPOINT
RESET CLUSTER SETTING
RESET {session variable}
RESTORE
RESUME JOB
RESUME SCHEDULES
REVOKE
ROLLBACK
SAVEPOINT
SELECT
FOR UPDATE
FOR SHARE
SET CLUSTER SETTING
SET {session variable}
SET TRANSACTION
SHOW BACKUP
SHOW CLUSTER SETTING
SHOW COLUMNS
SHOW CONSTRAINTS
SHOW CREATE
SHOW CREATE EXTERNAL CONNECTION
SHOW CREATE SCHEDULE
SHOW DATABASES
SHOW DEFAULT PRIVILEGES
SHOW ENUMS
SHOW FULL TABLE SCANS
SHOW GRANTS
SHOW INDEX
SHOW JOBS
SHOW LOCALITY
SHOW PARTITIONS
SHOW RANGES
SHOW RANGE FOR ROW
SHOW REGIONS
SHOW {session variable}
SHOW SUPER REGIONS
SHOW SYSTEM GRANTS
SHOW ROLES
SHOW SCHEDULES
SHOW SCHEMAS
SHOW SEQUENCES
SHOW SESSIONS
SHOW STATEMENTS
SHOW STATISTICS
SHOW SAVEPOINT STATUS
SHOW TABLES
SHOW TRACE FOR SESSION
SHOW TRANSACTIONS
SHOW TYPES
SHOW USERS
SHOW VIRTUAL CLUSTER
SHOW ZONE CONFIGURATIONS
TRUNCATE
UPDATE
UPSERT
WITH {storage parameter}
NULL
ARRAY
BIT
BOOL
BYTES
COLLATE
DATE
DECIMAL
ENUM
FLOAT
INET
INT
INTERVAL
JSONB
OID
SERIAL
STRING
TIME
TIMESTAMP
TSQUERY
TSVECTOR
UUID
POINT
LINESTRING
POLYGON
MULTIPOINT
MULTILINESTRING
MULTIPOLYGON
GEOMETRYCOLLECTION
ST_Contains
ST_Within
ST_Intersects
ST_CoveredBy
ST_Covers
ST_Disjoint
ST_Equals
ST_Overlaps
ST_Touches
ST_ConvexHull
ST_Union
cockroach start
cockroach init
cockroach start-single-node
cockroach cert
cockroach sql
cockroach sqlfmt
cockroach node
cockroach nodelocal upload
cockroach auth-session
cockroach demo
cockroach debug ballast
cockroach debug encryption-active-key
cockroach debug encryption-decrypt
cockroach debug job-trace
cockroach debug list-files
cockroach debug merge-logs
cockroach debug tsdump
cockroach debug zip
cockroach statement-diag
cockroach gen
cockroach userfile upload
cockroach userfile list
cockroach userfile get
cockroach userfile delete
cockroach version
cockroach workload
cockroach import
cockroach-sql
crdb_internal
information_schema
pg_catalog
pg_extension
An overview of common tasks that come up when you build an application using CockroachDB
Create and connect to a new CockroachDB cluster.
Install client drivers for your application.
Get details on how to connect to a CockroachDB cluster using your favorite language and framework.
Browse our example applications written in your favorite language and framework.
Browse our tutorials.
A quick overview of key concepts developers need to know about CockroachDB.
Submit SQL queries to retrieve data from your cluster.
Details and best practices about designing schemas for your data.
How to query your cluster to retrieve data.
How to insert data into your cluster.
Handle errors and solve problems with your application.
How to make your queries run as fast as possible.
Was this helpful?