AiData Sidekick helps people write SQL, documentation, and other tasks faster with powerful recipes.

AI Data Sidekick

AiData Sidekick is a free website that helps people write SQL, documentation, and other tasks 10x faster with powerful recipes and AI Query Doctor. Chrome/Firefox extensions available.

AirOps | Data unlocked. â10x faster with AI.
Data
Sidekick
Workspace
Pricing
Blog
Sign In
Get Started
Get Early Access
Now availablE
ð¦¸
â
AI
Data Sidekick
Write SQL, documentation and more 10x faster with our collection of powerful recipes.
Free
for individuals and small teams. ð¤©
ð¬ Watch Video
Get Started
ð¬ Watch Video
Popular Recipes Include
SQL Writer
Python Writer
SQL Fixer
SQL Writer
Which campaigns had the biggest drop in impressions in January of 2021
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
select
Â campaign_name,
Â impressions,
Â lag
(
impressions,
1
)
over
(
Â  Â partition
by
Â  Â  Â campaign_name
Â  Â
order by
Â  Â  Â day
Â
)
as
prev_impressions
from
Â marketing_sample.advertising_channels
as
ac
where
Â day
between
'2021-01-01'
and
'2021-01-31'
order by
Â impressions - prev_impressions
asc
Python Writer
Forecast clicks into the future by 6 months
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
#Import required libraries
import
pandas
as
pd
from
fbprophet
import
Prophet
#Read data from MARKETING_SAMPLE.ADVERTISING_CHANNELS table
data = pd.read_sql(
'SELECT * FROM MARKETING_SAMPLE.ADVERTISING_CHANNELS'
, con=conn)
#Create a dataframe with only the columns required for forecasting
df = data[[
'DT_CREATED'
,
'CLICKS'
]]
#Rename columns to fit the Prophet library requirements
df.columns = [
'ds'
,
'y'
]
#Instantiate Prophet object
Query Doctor
Please fix this query: 
SELECT il.label_id, COUNT(*) AS issue_count, MAX(l.name) AS label_name
FROM github.issue_label il
INNER JOIN github.label
ON il.label_id = id
GROUP BY il.label_id
ORDER BY issue_count DESC
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Error:
The table "label" is missing an alias.
Rewritten Query:
select
il.label_id,
count
(
*
)
as
issue_count, max
(
l.name
)
as
label_name
from
github.issue_label il
inner join
github.label l
on
il.label_id
=
l.id
group by
il.label_id
order by
issue_count
desc
;
Ask in natural language
Download for Chrome
Download for Firefox
Works best wherever you do
Web App
Chrome Extension
APIs
Firefox Extension
Now availablE
ð¦¸
â
AI
Data Sidekick
Write SQL, documentation and more 10x faster with our collection of powerful recipes.
Free
for individuals and small teams. ð¤©
ð¬ Watch Video
Get Started
Try it out ðª
Popular Recipes Include
SQL Fixer
Query Explainer
SQL Writer & more
SQL Fixer
Query Explainer
SQL Writer
Connect your data and try all recipes for free
Get Started
Ask in natural language
Download for Chrome
Download for Firefox
Works best wherever you do
Chrome Extension
Firefox Extension
Web App
APIs
Now availablE
ð¦¸
Introducing: the first
AI
Data Sidekick
Write SQL, documentation and more 3x as fast, wherever you work with data.
Get started for free
Free forever for individuals and small teams. ð¤©
SQL Writer
Which campaigns had the
biggest drop in impressions
in January of 2021
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
select
Â campaign_name,
Â impressions,
Â lag (impressions, 1) over (
Â  Â partition by
Â  Â  Â campaign_name
Â  Â order by
Â  Â  Â day
Â ) as prev_impressions
from
Â marketing_sample.advertising_channels as ac
where
Â day between '2021-01-01' and '2021-01-31'
order by
Â impressions - prev_impressions asc
Ask in natural language
Sidekick
Features
After
Before
After
ð
SQL Writer
Write SQL 3x as fast, wherever you work
AirOps SQL Writer uses your database schema to create queries, direct from natural language. Not sure which tables to use? It can help with that too.
Our
Recipe
Book
Fly through your work using any of our AIÂ powered recipes. Magical, whether you've been working with data for a day or a decade.
ð
SEO Helper
SEO optimize all of your product descriptions in one go.
ð·
Product Descriptions
Auto suggest product descriptions in your tone of voice.
ð±
Brand Helper
Generate brand ideas for your new Shopify store project.
ð»
Liquid Template Generator
Our code helper AI can help create and make changes to liquid template code.
ð§ª
a/b Test Creator
Our code helper AI can help create and make changes to liquid template code.
ð¨
Email writer
Write promotional emails using your shopify product data
âï¸
Collection writer
Write collection content.
Query Writer
Draft SQL queries with natural language. Type a question -> Get a query -> Execute a query.
Try now
SQL Fixer
Query won't run ð±? Explain and fix syntax errors in a flash.
Try now
Query Updater
Update a SQL query using natural language. Type your change â¡ï¸ get an updated query.
Try now
SQL Query Optimizer
Optimize any query to improve performance and trim your data bill ð¸
Try now
Question Suggestor
Suggest questions that a database table could answer. Uncover business value from your tables.
Try now
Table Documenter
Magically write draft documentation for any table
Try now
Query Explainer
Complex query? Instantly write a human-friendly description.
Try now
Python Script Creator
Generate a full python script from a table. Use any library.
Try now
Generate dbt Config
Kickstart your dbt project. Outputs a model .yaml entry for a given dbt SQL query.
Try now
dbt SQL
Draft a dbt SQL query with natural language.
Try now
dbt Python Creator
Generate a full python script from a dbt model.
Try now
âIâve never Â walked away from a product demo before with such an urge to tell other people about itâ
Tyler Wozny | Chief Digital Officer at Madison Reed
Free
for individuals and small teams
No credit card required.
Works with major data warehouses, or use our sample data.
Sidekick
ð¦¸
Sidekick
Lorem ipsum dolor sit amet
Lorem ipsum dolor sit amet
Lorem ipsum dolor sit amet
Get Started
Frequently Asked Questions
Can I invite my team to my Sidekick account?
You sure can! Just sign up, then you can start inviting your team. You may also want to check out AirOps Workspace - it's probably perfect for teams like yours.
How can I use Sidekick Recipes?
You can get started with our Chrome Extension and Web application. We have a Firefox extension and API (currently in beta) available on request. Or, if you're interested in developing a client for a SQL IDE or similar, drop us a line and let's chat!
I have an idea for a recipe or feature!
We'd love to hear it! Our team is shipping multiple times a day, so you may see your idea in action before you sit down for breakfast tomorrow. ð
Which warehouses and databases does Sidekick work with?
We currently support Snowflake, Redshift, BigQuery and Postgres databases. We're adding support for more in the next few weeks, let us know what's missing when you sign up.
Does Sidekick require database or warehouse access?
To get the most out of Sidekick, you should connect your data warehouse. If you want to play with Sidekick before you do that, just sign up and use the sample data that comes with your account. Some recipes don't use warehouse access at all including SQLÂ Fixing and Modifying.
Does Sidekick store my data?
We do not store your data. Our AI (powered by OpenAI) takes a look at your table schemas to generate SQL and do its other magic, but your data is always safe with you. For more information, contact us. We are SOC-2 Type 1 Certified (Type 2 coming very soon). More information at https://docs.airops.com/.
Is Sidekick free?
Absolutely! Sidekick is a big step toward our mission of giving data superpowers to everyone at work and we're making it available for free (with a reasonable usage cap). We've also been hard at work on our core product, AirOps Workspace, and it's launching early next year. If you'd like to check it out, schedule a demo with us and let us show you what we've been cooking up.
FOR Your Team
AirOps
Workspace
.
GPT-3Â + Your data = ð¤¯
â
Set up your first data stack instantly or connect existing
â
Explore and organize data using AI and natural language
â
Create docs, sheets, APIs and more
Learn more
Latest from our team
Using AI to generate YAML entries for dbt models
How to automatically write dbt SQL queries using AI
Automatically document SQL tables using AI
Using AI to optimize your SQL queries
How to create Python scripts automatically using AI
How to use AI to automatically generate a Python script using dbt syntax
Explain complex SQL queries using AI
How to instantly fix SQL queries using AI
Â© 2022 AirOps. All rights reserved.
Join Our Team
SQL Guides
Status
Contact
Privacy Policy
Terms

AiData Sidekick is a website that helps people write SQL, documentation, and other tasks 10 times faster by providing them with powerful recipes. It is free for individuals and small teams to use. They provide popular recipes such as SQL Writer, Python Writer, SQL Fixer, Query Explainer, and more. There are also Chrome and Firefox extensions available to help people use the website wherever they are. The website also has an AI Query Doctor which can help users fix any queries they have written. Finally, users can connect their data and try all recipes for free.

Airops - Data Unlocked. 10X Faster With Ai.

Share:

Tags:

Similar Tools and Alternatives

Airops - Data Unlocked. 10X Faster With Ai.self.__wrap_b(":R39j4m:",1)

Share:

Tags:

Similar Tools and Alternatives

Airops - Data Unlocked. 10X Faster With Ai.