CockroachDB: API, Integrations & Data Access

OVERALL CONTROL / 0.6-customer-control

Grades and scoring

Overall B / 7.1^*/10, with 12 of 16 applicable scoring inputs verified. Missing evidence discounts the supported score (unknown answers remain unknown).

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

Data access and planned exit carry the most weight. Known commercial barriers cap access; an unpublished price applies a bounded discount. Post-cancellation retrieval is a separate disclosure. Open each dimension to inspect its inputs and sources.

Access barriers

Minimum plan: Named minimum plan not established for the assessed route.
Sources & scope
CockroachDB SQL EXPORT ↗Export using a SELECT statement and non-distributed SQL-client export · Checked 2026-10-22
API fees: Exact customer and partner API charges not established; confirm the selected route.
Sources & scope
CockroachDB SQL EXPORT ↗Export using a SELECT statement and non-distributed SQL-client export · Checked 2026-10-22
Credentials: Cloud connections select a cluster, SQL user and database. Use the deployment’s documented connection and TLS settings; cluster-console access is separate.
Sources & scope
CockroachDB Cloud SQL connections ↗SQL user and client connection setup · Checked 2026-10-22
Approval: Cloud connections select a cluster, SQL user and database. Use the deployment’s documented connection and TLS settings; cluster-console access is separate.
Sources & scope
CockroachDB Cloud SQL connections ↗SQL user and client connection setup · Checked 2026-10-22
Recovery limits: Repeat the declared collection or export route to rebuild current state within its permissions and selection limits. Deleted payloads and intermediate history are unverified.
Sources & scope
CockroachDB SQL EXPORT ↗Export using a SELECT statement and non-distributed SQL-client export · Checked 2026-10-22

Routes differ (plan prices and API surcharges are separate). Unestablished fees do not mean free access.

A8.0^*/10

Data access

25% of the overall score before applicability adjustment.

Scored answers and evidence

Read interface 10.0/10

Queryable database or replicated schema

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

CockroachDB exposes SQL table queries and exports to CSV or Parquet. Exported rows do not include a complete cluster definition.

CockroachDB SQL EXPORT ↗
Export using a SELECT statement and non-distributed SQL-client export · Checked 2026-10-22

Answer-to-score anchors ↗

Bulk delivery 10.0/10

Customer-initiated native snapshot or full scoped table export

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

Use EXPORT INTO for the chosen table or query, or write SQL-client CSV output to a customer-held file.

CockroachDB SQL EXPORT ↗
Export using a SELECT statement and non-distributed SQL-client export · Checked 2026-10-22

Answer-to-score anchors ↗

Query expressiveness 10.0/10

SQL or equivalent joins and aggregations against the operational system

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

SQL predicates and projections select exported rows. Destination permissions and query consistency must be checked separately.

CockroachDB SQL EXPORT ↗
Export using a SELECT statement and non-distributed SQL-client export · Checked 2026-10-22

Answer-to-score anchors ↗

Access cost barrier -

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

Minimum commercial entitlement and exact API charges were not established for the assessed route.

CockroachDB SQL EXPORT ↗
Export using a SELECT statement and non-distributed SQL-client export · Checked 2026-10-22

Answer-to-score anchors ↗

A8.8^*/10

Third-party accessibility

20% of the overall score before applicability adjustment.

Scored answers and evidence

Third-party eligibility 10.0/10

Customer authorization without discretionary provider approval

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

Cloud connections select a cluster, SQL user and database. Use the deployment’s documented connection and TLS settings; cluster-console access is separate.

CockroachDB Cloud SQL connections ↗
SQL user and client connection setup · Checked 2026-10-22

Answer-to-score anchors ↗

Downstream permission -

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

Processing, AI-use, redistribution and other downstream contractual permissions were not settled by this technical review.

CockroachDB Cloud SQL connections ↗
SQL user and client connection setup · Checked 2026-10-22

Answer-to-score anchors ↗

A8.5/10

External action

15% of the overall score before applicability adjustment.

Scored answers and evidence

Write interface 7.5/10

Create and update in one business domain

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

INSERT creates table rows within the SQL user’s privileges; other schema and operational changes remain separately permissioned.

CockroachDB INSERT statement ↗
INSERT syntax and required privileges · Checked 2026-10-22

Answer-to-score anchors ↗

Custom application path 10.0/10

Customer applications using fixed APIs without provider selection

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

The documented interface can connect customer application code within its authorization and resource scope.

CockroachDB Cloud SQL connections ↗
SQL user and client connection setup · Checked 2026-10-22

Answer-to-score anchors ↗

D3.1^*/10

Continuity

15% of the overall score before applicability adjustment.

Scored answers and evidence

Refresh mechanism 5.0/10

Scheduled feeds or recurring extracts

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

Repeat the assessed collection traversal to reconcile current state. Native change delivery and retained replay were not established in this review.

CockroachDB SQL EXPORT ↗
Export using a SELECT statement and non-distributed SQL-client export · Checked 2026-10-22

Answer-to-score anchors ↗

Limit visibility -

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

A numeric request budget and recovery contract were not established by the reviewed references.

CockroachDB SQL EXPORT ↗
Export using a SELECT statement and non-distributed SQL-client export · Checked 2026-10-22

Answer-to-score anchors ↗

CDC and deletion capture 2.5/10

Full snapshots permit customer reconciliation; native deltas unverified

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

Compare complete scoped snapshots to reconcile missing records; native deletion identities and intermediate changes were not established.

CockroachDB SQL EXPORT ↗
Export using a SELECT statement and non-distributed SQL-client export · Checked 2026-10-22

Answer-to-score anchors ↗

Replay and gap recovery 2.5/10

Rebuild from a fresh snapshot; no historical replay established

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

Repeat the declared collection or export route to rebuild current state within its permissions and selection limits. Deleted payloads and intermediate history are unverified.

CockroachDB SQL EXPORT ↗
Export using a SELECT statement and non-distributed SQL-client export · Checked 2026-10-22

Answer-to-score anchors ↗

B7.5/10

Data exit

20% of the overall score before applicability adjustment.

Scored answers and evidence

Export custody 7.5/10

Customer-held structured files or API records

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

The assessed structured payloads can be retained in customer-held files. Broader contractual reuse rights remain unresolved.

CockroachDB SQL EXPORT ↗
Export using a SELECT statement and non-distributed SQL-client export · Checked 2026-10-22

Answer-to-score anchors ↗

Post-cancellation access Disclosure

Disclosure only; does not reduce planned-exit credit.

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

The reviewed technical documentation does not establish retrieval rights after account termination.

CockroachDB Cloud SQL connections ↗
SQL user and client connection setup · Checked 2026-10-22

Answer-to-score anchors ↗

Planned migration fidelity 7.5/10

Portable structured records on documented routes; whole-product completeness unverified

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

CSV or Parquet retains the selected query’s records. Schema, privileges, sequences and complete cluster restore require separate routes.

CockroachDB SQL EXPORT ↗
Export using a SELECT statement and non-distributed SQL-client export · Checked 2026-10-22

Answer-to-score anchors ↗

D2.1^*/10

Business logic and customization

5% of the overall score before applicability adjustment.

Scored answers and evidence

Logic authoring 2.5/10

External integration code; native business logic portability not established

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

External code can use this interface; native workflow portability was not established (API clients and native definitions are different artifacts).

CockroachDB Cloud SQL connections ↗
SQL user and client connection setup · Checked 2026-10-22

Answer-to-score anchors ↗

Rights to custom logic -

CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded.

Ownership and reusable export rights for native workflow artifacts need a separate contractual review.

CockroachDB Cloud SQL connections ↗
SQL user and client connection setup · Checked 2026-10-22

Answer-to-score anchors ↗

Scores are out of 10. * Incomplete evidence discounts verified capabilities (unknown answers stay unknown). Planned migration drives data exit. Scoring method ↗

CUSTOMER CHOICE

Third-party accessibility

Cloud connections select a cluster, SQL user and database. Use the deployment’s documented connection and TLS settings; cluster-console access is separate.

Third-party eligibilityCustomer authorization without discretionary provider approvalSource & scope ↗

Access cost barrier-Source & scope ↗

Downstream permission-Source & scope ↗

Confirm who can connect, who owns the credentials and which uses are permitted. Customer consent and provider approval can be separate requirements; the selected plan and contract still matter.

READ / INTEGRATE

API and export routes

Use EXPORT INTO for the chosen table or query, or write SQL-client CSV output to a customer-held file. SQL predicates and projections select exported rows. Destination permissions and query consistency must be checked separately.

Access route	Authentication	Credential owner	Provider approval	Access requirement	Last checked
Cloud SQL connections, table/query export and INSERT	database credentials	Customer	No	Customer-supplied credentials	2026-10-22

Availability depends on your product, plan and agreement. See the documentation below for the requirements of each route.

ECONOMIC ACCESS

Cost, authentication and limits

Minimum plan and exact route fees remain unconfirmed.

Check API entitlement, credential ownership and rate limits for the route you intend to use. Include review fees, customer-plan upgrades and ongoing access charges in the total.

ACT FROM OUTSIDE

External action

INSERT creates table rows within the SQL user’s privileges; other schema and operational changes remain separately permissioned.

Validate the supported operation, acting identity and permission scope (read access does not imply write permission). Ambiguous retries and revoked credentials also affect whether an external workflow can run safely.

KEEP ACCESS USEFUL

Continuity

Repeat the assessed collection traversal to reconcile current state. Native change delivery and retained replay were not established in this review.

CDC, deletions and recovery

Question	Answer / applicable route	Evidence
Can ongoing extraction identify updates and deleted records on the declared route?	Full snapshots permit customer reconciliation; native deltas unverifiedCockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. Compare complete scoped snapshots to reconcile missing records; native deletion identities and intermediate changes were not established.	CockroachDB SQL EXPORT ↗Export using a SELECT statement and non-distributed SQL-client exportChecked 2026-10-22
How can extraction recover after missed events or an interrupted consumer?	Rebuild from a fresh snapshot; no historical replay establishedCockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. Repeat the declared collection or export route to rebuild current state within its permissions and selection limits. Deleted payloads and intermediate history are unverified.	CockroachDB SQL EXPORT ↗Export using a SELECT statement and non-distributed SQL-client exportChecked 2026-10-22

Useful ongoing access includes corrections and deletions, not only the first export. A failed request, changed filter or lost resource permission should not be interpreted as a deleted record.

LEAVE WITH YOUR DATA

Data exit and portability

CSV or Parquet retains the selected query’s records. Schema, privileges, sequences and complete cluster restore require separate routes.

Test the output against the destination’s required fields and history. Check stable identifiers, relationships, attachments and extraction time; a sample file proves only the coverage of that sample.

BUILD / INSPECT / REUSE

Business logic and customization

Customers can write external integration code. Native workflow rights and independent execution remain unresolved (record access does not establish portable application logic).

Custom API access, ownership of workflows and the right to export their definitions are separate questions. A custom-app capability alone does not establish that business rules can move to another system.

AGREEMENTS / API DOCS / PROGRAM REQUIREMENTS

Documented conditions

Answers below come from public provider materials. Every answer retains its source check date, scope (a partner agreement does not describe every customer route). Customer contracts and live behavior still need verification.

Question	Answer / applicable route	Evidence
What structured read interface is documented?	Queryable database or replicated schemaCockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. CockroachDB exposes SQL table queries and exports to CSV or Parquet. Exported rows do not include a complete cluster definition.	CockroachDB SQL EXPORT ↗Export using a SELECT statement and non-distributed SQL-client exportChecked 2026-10-22
How can customers retrieve data in bulk?	Customer-initiated native snapshot or full scoped table exportCockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. Use EXPORT INTO for the chosen table or query, or write SQL-client CSV output to a customer-held file.	CockroachDB SQL EXPORT ↗Export using a SELECT statement and non-distributed SQL-client exportChecked 2026-10-22
What queries can a customer issue outside the provider UI?	SQL or equivalent joins and aggregations against the operational systemCockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. SQL predicates and projections select exported rows. Destination permissions and query consistency must be checked separately.	CockroachDB SQL EXPORT ↗Export using a SELECT statement and non-distributed SQL-client exportChecked 2026-10-22
Who decides whether a chosen third party may connect?	Customer authorization without discretionary provider approvalCockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. Cloud connections select a cluster, SQL user and database. Use the deployment’s documented connection and TLS settings; cluster-console access is separate.	CockroachDB Cloud SQL connections ↗SQL user and client connection setupChecked 2026-10-22
What extra commercial condition applies to the routes supplying the assessed read capability, relative to the lowest paid plan?	-CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. Minimum commercial entitlement and exact API charges were not established for the assessed route.	CockroachDB SQL EXPORT ↗Export using a SELECT statement and non-distributed SQL-client exportChecked 2026-10-22
Which external write operations are documented?	Create and update in one business domainCockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. INSERT creates table rows within the SQL user’s privileges; other schema and operational changes remain separately permissioned.	CockroachDB INSERT statement ↗INSERT syntax and required privilegesChecked 2026-10-22
How can customers connect an application they build or choose?	Customer applications using fixed APIs without provider selectionCockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. The documented interface can connect customer application code within its authorization and resource scope.	CockroachDB Cloud SQL connections ↗SQL user and client connection setupChecked 2026-10-22
What mechanism supports repeatable extraction of changes?	Scheduled feeds or recurring extractsCockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. Repeat the assessed collection traversal to reconcile current state. Native change delivery and retained replay were not established in this review.	CockroachDB SQL EXPORT ↗Export using a SELECT statement and non-distributed SQL-client exportChecked 2026-10-22
How are integration limits disclosed?	-CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. A numeric request budget and recovery contract were not established by the reviewed references.	CockroachDB SQL EXPORT ↗Export using a SELECT statement and non-distributed SQL-client exportChecked 2026-10-22
Where can a usable data copy be delivered?	Customer-held structured files or API recordsCockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. The assessed structured payloads can be retained in customer-held files. Broader contractual reuse rights remain unresolved.	CockroachDB SQL EXPORT ↗Export using a SELECT statement and non-distributed SQL-client exportChecked 2026-10-22
What retrieval rights are documented at cancellation?	-CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. The reviewed technical documentation does not establish retrieval rights after account termination.	CockroachDB Cloud SQL connections ↗SQL user and client connection setupChecked 2026-10-22
How can customers define their own business logic?	External integration code; native business logic portability not establishedCockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. External code can use this interface; native workflow portability was not established (API clients and native definitions are different artifacts).	CockroachDB Cloud SQL connections ↗SQL user and client connection setupChecked 2026-10-22
What rights or portability are documented for custom workflow artifacts?	-CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. Ownership and reusable export rights for native workflow artifacts need a separate contractual review.	CockroachDB Cloud SQL connections ↗SQL user and client connection setupChecked 2026-10-22
What usable data or native definitions can leave before cancellation?	Portable structured records on documented routes; whole-product completeness unverifiedCockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. CSV or Parquet retains the selected query’s records. Schema, privileges, sequences and complete cluster restore require separate routes.	CockroachDB SQL EXPORT ↗Export using a SELECT statement and non-distributed SQL-client exportChecked 2026-10-22
What permission is needed for the documented downstream use?	-CockroachDB / Cloud SQL connections, table/query export and INSERT; changefeeds, database backups and complete cluster migration are excluded. Processing, AI-use, redistribution and other downstream contractual permissions were not settled by this technical review.	CockroachDB Cloud SQL connections ↗SQL user and client connection setupChecked 2026-10-22

SOURCES / SCOPE / HISTORY

Sources and open questions

This review is based on the documentation below. Live account behavior and customer-specific agreements haven’t been tested.

Still to confirm

Minimum commercial entitlement and exact API charges
Downstream contractual permissions and post-cancellation retrieval rights
Complete migration of history, files, permissions and native workflow definitions

Documentation

CockroachDB SQL EXPORTwww.cockroachlabs.com · Checked 2026-10-22 ↗CockroachDB Cloud SQL connectionswww.cockroachlabs.com · Checked 2026-10-22 ↗CockroachDB INSERT statementwww.cockroachlabs.com · Checked 2026-10-22 ↗

Assessment checked 2026-10-22. Each answer retains its source and applicable route; the check date does not establish live account behavior.