Introduction to EZQL

EZQL is our AI agent that allows everyone to query their data even if their not SQL experts.

Overview

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.

Example

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.