How do I connect CockroachDB to Querri?
Ask the Connector Agent for CockroachDB, then enter the host, port, database, user and password. Pick a TLS mode: verify-full for CockroachDB Cloud, require for a cluster with its own CA. Choose a schema, public by default, and the tables to bring in.
What CockroachDB data comes into Querri?
The tables and views in the schema you choose, with their columns and types. CockroachDB's internal schemas, such as crdb_internal and pg_catalog, are left out of the picker, and only the tables you select are copied.
How often is CockroachDB data refreshed?
Each table follows the schedule you give it. Choose a full reload daily, weekly or monthly, or an incremental sync hourly, daily or weekly that brings in only rows where a cursor column like updated_at has moved forward since the last run.
Why not use the PostgreSQL connector for CockroachDB?
CockroachDB speaks the PostgreSQL wire protocol, but Querri's PostgreSQL connector reads tables with a binary COPY command that CockroachDB has not implemented. The CockroachDB connector reads through a CockroachDB-specific driver instead, so use it for any CockroachDB cluster.
Does Querri change anything in CockroachDB?
No. Querri only reads from CockroachDB. It never creates, edits or deletes records there, and every answer runs on Querri's own copy of the data.
Is my CockroachDB data secure in Querri?
Yes. Querri is SOC 2 Type II, HIPAA and ISO 27001:2022 certified, credentials are stored encrypted, and your data is never used to train a model.