EZQL is our AI agent that allows everyone to query their data even if their not SQL experts.
EZQL is powered by OpenAI's
gpt-3.5-turbo-16k model, none of your data is stored or used to further train their models.
How it works
EZQL understands how your database is structured, it's schema, tables, and even the foreign keys and indexes to understand the relationship between your columns.
Getting better results
Sometimes data isn't as clean as we'd like it to be, or the naming may be internally known but would not be clear to those outside your company. With our Data Catalog feature you can add metadata to your database and each of your columns and tables to provide EZQL with more context.
Let's say my data looks something like this
CREATE TABLE users ( id INT PRIMARY KEY AUTO_INCREMENT, username VARCHAR(50), email VARCHAR(50), date_created TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
I can ask EZQL:
Who signed up in the last week?
And it would return
SELECT COUNT(*) FROM users WHERE date_created >= NOW() - INTERVAL 1 WEEK;
Now this is a very basic example, EZQL can handle complex queries, cross table joins and much more.