Yes, right. AI can write SQL queries for you. It can understand your database schema, generate SQL queries, and even interact with you to enhance them.
Let's create a bot that helps you write SQL queries, and invite the bot to your communication platforms, such as Slack or Microsoft Teams. It takes 20 minutes to create this without coding.
The image below shows how it works in Slack. Awesome, isn't it?
How to Create It
Don't worry. You don't need engineering knowledge to create yours.
Here are the simple steps:
- Extract database schema.
- Create an Assistant using OpenAI or Anthropic.
- Invite the Assistant to your communication platform using Runbear.
Let's go through one by one.
1. Extracting database schema
This is the only step you may need help from engineers.
You can extract database schema in many ways. For example, you can extract PostgreSQL database schema using this command:
psql -c "\d *"With proper parameters, you will get table descriptions like this:
Table "public.User"
Column | Type | Collation | Nullable | Default
------------+--------------------------------+-----------+----------+-------------------
id | uuid | | not null |
email | text | | not null |
createdAt | timestamp(6) with time zone | | not null | CURRENT_TIMESTAMP
updatedAt | timestamp(6) with time zone | | not null |
firstName | text | | |
lastName | text | | |
orgId | text | | not null |2. Creating an Assistant
If you are a Runbear user, simply visit the "Assistants" page and click the "Create" button to create your Assistant that uses OpenAI or Anthropic.
All you need is to write simple instructions and attach the table descriptions. Here is an example:
