Engineering

Sync your database - How it works

With Velvet, any product stakeholder can securely query your database alongside additional data sources. Execute complex joins without painful data transformations or ongoing engineering support.

Sync your database to Velvet

Velvet manages the complexity of data engineering for you. Once you connect your database, any contributor can ask natural language questions. The AI editor writes SQL for you and performs native joins on top of your live data.

Simply paste in your read-only connection string and configure your tables. Use the AI editor to write SQL and return live data results that can be saved or used in production.

Read our docs to get started.

How it works

No more painful data transformations or migrations required. We leverage ClickHouse’s Table Engines to give you direct read access to your databases, 3rd-party APIs, and events. Each workspace is isolated as a separate database. And access is granular, with specific readonly query users per workspace.

Connecting your database is easy and secure. We partnered with the team at Noble IP to support first-party static IP addresses. Database credentials are encrypted using pgsodium's Transparent Column Encryption (TCE) with Postgres.

Once your data is connected, our editor uses LLMs (currently OpenAI and Azure) to write complex SQL for you. We generate dynamic context based on your unique data model. Use the editor to build iterative queries, return results in milliseconds, and collaborate with stakeholders.

Learn more about how it works in our infrastructure and security articles.

Streamline your workflow

Query all your data in one simple interface — get native feeling joins across synced databases, 3rd party APIs, and event streams.

Email us any time at team@usevelvet.com, or schedule a call here.

More articles

Product
Enter the Velvet challenge

Collect the most points for the chance to win a cash prize.

Engineering
Sync your database - How it works

Securely connect and query your database with Velvet.

Product
How we used Velvet during our product launch

Using Velvet to analyze our launch and automate onboarding.

ai-first data platform

Make everyone on your team a data engineer.

Try Velvet for free