Skip to main content
CockroachDB is PostgreSQL wire-compatible, so you connect it as a PostgreSQL database in VexiData.

​
Prerequisites

​
Connect CockroachDB to VexiData

1

Get your connection details

  1. Log in to the CockroachDB Cloud Console
  2. Select your cluster
  3. Click the Connect button (top right)
  4. Select Parameters only to view individual values:
ParameterExample
Hostmy-cluster.gcp-us-east1.cockroachlabs.cloud
Port26257
Databasedefaultdb
Usernameroot
PasswordYour database password
CockroachDB uses port 26257, not the standard PostgreSQL port 5432.
2

Add VexiData to the IP allowlist

CockroachDB Cloud blocks all connections by default. You must add VexiData’s IP addresses.
  1. Go to your cluster’s Networking page
  2. Click the IP Allowlist tab
  3. Click Add Network
  4. Add each of VexiData’s IPs:
NameNetwork
VexiData 1139.59.53.167/32
VexiData 2165.22.217.42/32
  1. Select CockroachDB Client for the access type
  2. Click Apply
IP allowlist configuration is mandatory. Your connection will fail without this step.
3

Add the connection in VexiData

  1. Go to Data Sources in VexiData
  2. Click PostgreSQL to open the connection form (CockroachDB is PostgreSQL-compatible)
  3. Fill in the details:
FieldValue
Display NameA name to identify this connection (e.g., “CockroachDB Production”)
HostYour cluster hostname (e.g., my-cluster.gcp-us-east1.cockroachlabs.cloud)
Port26257
Databasedefaultdb (or your database name)
Schemapublic (default)
Usernameroot (or your user)
PasswordYour database password
4

Test and save

Click Test & Save Connection. VexiData will verify it can reach your database. Once connected, your schema will be analyzed automatically.

​
Troubleshooting

  • Verify VexiData’s IPs are in your cluster’s IP Allowlist — CockroachDB blocks all connections by default
  • Make sure you’re using port 26257, not 5432
  • Check that your cluster is running in the CockroachDB Console
  • Double-check your credentials from the Connect dialog in the CockroachDB Console
  • If you’ve forgotten your password, reset it from the cluster’s SQL Users page
  • Confirm your tables are in the public schema
  • Check the correct database name — CockroachDB uses defaultdb by default
  • CockroachDB is PostgreSQL wire-compatible but not identical. Most standard queries work, but some PostgreSQL-specific features (like certain data types or extensions) may not be supported