Skip to main content

Get started with PG Studio

Open the SQL editor or Table editor and run your first queries.

note

PG Studio and its AI features are on by default, so no setup is needed. To turn them off, see Manage PG Studio and AI features.

Prerequisites​

To use PG Studio, you need:

  • Aiven permissions: The service:data:write permission at the organization, unit, or project level. This permission is included in the Admin, Developer, and Operator roles.
  • Network access: Your IP address must be in the service's IP allowlist. PG Studio validates your browser's IP address, which must be allowed in the service's IP filter configuration. If you get the Access is not allowed from the IP address error, add your IP address to the allowlist.

Open the SQL editor or Table editor​

  1. In the Aiven Console, open your Aiven for PostgreSQL service.
  2. Click SQL editor or Table editor in the left-hand menu.
  3. Click the source database and schema selectors.

If AI features are off for your organization, the AI Assistant panel does not appear.

Run your first query​

You can write SQL directly. If AI features are on, you can also use the AI Assistant to generate queries:

Write SQL manually​

  1. In the SQL editor, enter your query, for example:

    SELECT * FROM users LIMIT 10;

  2. Click Run.

  3. View the results in the results panel.

Generate SQL with AI​

  1. In the AI Assistant panel, describe what you need, for example: Show all users who signed up in the last 7 days.
  2. Review the generated SQL in the SQL editor.
  3. Click Run to execute the query.

Explore your schema​

  1. Click Table editor in the left-hand menu.
  2. Click Open schema map to view your database structure as an interactive diagram.
  3. Browse tables, columns, and relationships.