Introducing Aiven’s New PG AI Editor - A simpler, faster, developer-friendly way to work with PostgreSQL.
Subscribe for the latest news and insights on open source, Aiven offerings, and more.
The new PG AI Editor gives you an easy way to run SQL directly inside Aiven - no setup, no switching tools.
With the built-in AI assistant, you can describe what you want in plain text and instantly turn it into runnable SQL.
The PG Editor is built to be simple and familiar: open it, write your query, run it, and see the results immediately in a clear, structured layout.
It removes the typical overhead of configuring clients or juggling multiple tools - everything happens right inside the console - nothing to install or configure.
It’s perfect for everyday developer tasks: checking tables, validating assumptions, debugging issues, and exploring data.
Alongside the editor, we added an AI-powered chat experience.
You can start with any database and explore its structure by viewing a schema map:
Once you understand how the database is structured, you can ask the AI assistant to run queries for you.
Simply describe what you want - for example, “Show me all customers who purchased in the last 7 days” - and the AI generates a ready-to-run SQL query:
You can then run the query directly and instantly see the results:
Q: Is my data used to train the AI models?
A: No. Your database content is not used to train our AI models.
Q: Can I edit the queries after the AI generates them?
A: Yes! All AI-generated SQL is fully editable. You can refine, modify, or optimize it as you like.
Q: Is this safe for production data?
A: Yes. Queries run in your database environment just like any other SQL, so standard database permissions and safeguards apply.
You can create a free PostgreSQL service in minutes and start using the PG AI Editor right away!
The PG AI Editor is just one part of making your PostgreSQL experience easier.
In Aiven, we build tools that help you work smarter and faster with your database:
Check out our Free Dev Tools!
