Databases
CockroachDB integration
Connect CockroachDB and chart your distributed SQL data in dashboards built from plain language.
Flitch is an AI BI tool that connects to CockroachDB and turns your tables into shareable dashboards. CockroachDB spreads your SQL data across nodes for resilience, and Flitch reads it safely over a connection string, client certificate or SSO. Pick the tables you want, ask for KPI, activity or revenue views, and schedule refresh so every dashboard stays live.
- Connect with read-only credentials
- Use any table or write custom SQL
- Schedule background refresh
How do you connect CockroachDB to Flitch?
Connect securely with your database credentials. Flitch only needs read access.
Generate a dashboard
Pick a prompt to get started.
CockroachDB integration FAQ
How do I connect CockroachDB to Flitch?
Add CockroachDB with a connection string, a client certificate for mTLS, or JWT / SSO, then pick your tables. The connection is read-only.
Does Flitch support CockroachDB SSO?
Yes. Alongside connection strings and client certificates, Flitch can connect with JWT / SSO. It only ever reads the data you select.
Do I need SQL to chart CockroachDB data?
No. Describe your dashboard in plain language and Flitch builds it. Custom SQL is available when you want it.
Which CockroachDB tables can I use?
You choose the tables or queries to import as datasets, then build dashboards spanning them.
How often does my CockroachDB dashboard refresh?
Set a background refresh schedule and Flitch re-pulls your data on that cadence to keep dashboards current.
Does Flitch copy my CockroachDB data?
No. Flitch queries CockroachDB where it sits and pushes the aggregation down as SQL, so it reads back totals rather than holding a copy of your tables. Nothing to keep in step, nothing extra to secure, and a large table stays your database's problem rather than something Flitch has to store. The queries are generated against your data model, so a figure means the same thing on every dashboard built from it.
More in Databases
Not the source you're after?