PG Studio for Aiven for PostgreSQL® Early availability

Aiven PG Studio is the name for the SQL and table editing tools built into the Aiven Console for Aiven for PostgreSQL®. PG Studio isn't a single item you open in the console. It's made up of two separate entities in the left-hand menu, the SQL editor and the Table editor.

note

PG Studio and its AI features are on by default. To turn off PG Studio or its AI features, contact the Aiven support team.

important

PG Studio is an Early availability feature.

What PG Studio offers

PG Studio supports:

Writing SQL in plain English or any other language
Autocompleting SQL queries with the Tab key, based on PostgreSQL commands and your schema
Visualizing your database structure with an interactive schema map
Exploring tables in the Table editor with data preview
Exploring schemas and table relationships
Explaining queries and database objects
Running a single query or multiple selected queries at once, with live results in separate tabs
Executing write queries and data definition statements with built-in safety guardrails

PG Studio components

PG Studio consists of two components, each available as a separate entity in the left-hand menu of the Aiven Console:

SQL editor:

Write and edit SQL across multiple tabs. Run a single statement or select multiple statements to execute them all at once, with each result shown in its own tab. Execute write operations with built-in safety guardrails.
AI Assistant panel: Describe what you need in natural language. The assistant generates SQL or explains queries, tables, and relationships using your database schema.

Table editor:

Browse tables in your selected schema and preview table data.
Schema map: View your database structure as an interactive diagram showing tables, columns, and relationships. Click the copy icon next to a table name to copy it to the clipboard.
No AI Assistant: The Table editor doesn't include the AI Assistant panel available in the SQL editor.