PG Studio for Aiven for PostgreSQL® Early availability
Aiven PG Studio lets you write, understand, and run SQL queries in the Aiven Console using natural language. It combines an SQL editor with an AI assistant that uses your database schema to generate and explain queries.
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
Tabkey, based on PostgreSQL commands and your schema - Visualizing your database structure with an interactive schema map
- Exploring schemas and table relationships
- Explaining queries and database objects
- Running queries with live results
PG Studio components
- Schema visualization: View your database structure as an interactive diagram showing tables, columns and relationships. Open it from Open schema map or request it from the AI Assistant panel. Click the copy icon next to a table name to copy it to the clipboard.
- SQL editor: Write and edit SQL across multiple tabs, and run queries to view results in the results panel.
- AI Assistant panel: Describe what you need in natural language. The assistant generates SQL or explains queries, tables and relationships using your database schema.
Get started with PG Studio
Get started
Open PG Studio and run your first queries.
Use AI Assistant
Generate and explain SQL queries with natural language.
Write and run queries
Use the SQL editor to write, edit, and execute queries.
Manage queries
Save and organize your queries for reuse.
Security and connections
Understand how PG Studio connects and protects your data.