How to automatically write SQL with AI

To write an effective SQL query that can pull in your desired data, you need to understand your database, its hierarchy, and the data model within it…

… or rather, you used to need those things.

Data Sidekick: An AI SQL writer that writes queries 10x faster

Data Sidekick makes common data tasks, like writing SQL, effortless. It works by combining the power of artificial intelligence with context from your data warehouse.

To generate a SQL query, simply select your table (or tables), type your question in plain English, and click Generate. In a few short seconds you’ll have a SQL query that you can use inside of AirOps, or wherever else you work with data.

In addition to automatically writing SQL queries, you can also use Sidekick’s collection of AI-powered recipes to:

• Explain, modify, and fix existing SQL queries 🔧
• Suggest questions a specific database table can answer 🧐
• Auto document table schemas ✍️
• Optimize queries to improve speed and trim your warehouse bill 💸

… and more. New recipes are always in the works, too.

The best part? Sidekick is completely free for individual users. You don’t even need a credit card to create an account.

AI Data Sidekick IRL

Curious about how Sidekick performs in the wild?

Check out this feedback from Megan Hettwer, Content Lead at AirOps, to see how she uses the SQL Query Writer recipe to expand her data abilities. ⬇