Stay organized with collections
Save and categorize content based on your preferences.
This page explains how to explore and manage your AlloyDB for PostgreSQL data
using AlloyDB Studio in the Google Cloud console.
AlloyDB Studio includes an Explorer pane that
integrates with a query editor and a SQL query results table.
You can run DDL, DML, and DQL statements from this single interface. For
example, instead of configuring a third-party database query tool, you can
create a table or query your data using this query editor.
You can use the Explorer pane in AlloyDB Studio to view and interact
with your database objects. You can create, alter, and delete the following
database objects:
Schemas
Tables
Columns
Indexes and keys
Triggers
Views
Functions
Procedures
Sequences
Types
Extensions
Required roles and permissions
To use AlloyDB Studio, you need the following permissions:
Additionally, ensure that
you have database-level permissions
for the database that you use for authentication.
Choose a database authentication method
Before you can access a database in AlloyDB Studio, you must first select a
database authentication method. To sign in to your database using
AlloyDB Studio, you can use one of the following types of authentication:
IAM database authentication: use IAM
authentication to manage the database access and privileges for users in your
organization. To use this, set up
IAM authentication
on the instance.
Built-in database authentication: connect to the database in
AlloyDB Studio by using your PostgreSQL user account and credentials. For
more information, see
Manage PostgreSQL users with built-in authentication.
Explore your data
To access the Explorer pane, follow these steps:
In the Google Cloud console, open the AlloyDB page.
Click Authenticate. The Explorer pane displays a list of the objects
in your database.
Create, modify, and query your data
You can use the query editor to run SQL statements. Statements must be separated
by a semicolon. Compose a query yourself, or populate the query editor with a
template.
Statement execution is based on the order in which you enter them in the query
editor.
To create, query, or modify your data, follow these steps:
In the Google Cloud console, open the AlloyDB page.
Sign in to AlloyDB Studio using the name of your database, username,
and password.
Compose a query using one of the following methods:
To compose your own query, follow these steps:
Click addNew SQL editor tab or addNew tab to open a new tab.
When the query editor appears, write your query.
To compose a query that starts with a template, follow these steps:
In the Explorer pane, next to a database object,
click more_vertView actions. One or more available actions appear.
Click an action. The query editor populates with a template.
Replace any placeholders in the template.
Click Run. This executes all the queries in the query editor. The
results of your query appear in the Results table.
You can also select and execute one or multiple queries at the same time.
To do this, select a query or multiple queries and click Run selected.
Limitations
AlloyDB Studio supports lightweight queries. Responses over 10MB might
be truncated. AlloyDB Studio indicates when it returns partial results.
Long-running queries or index creations on large tables that exceed five
minutes on the instance are timed-out and cancelled.
AlloyDB Studio doesn't keep a database connection open after execution
of a SQL script is complete. Similarly, the Editor tabs don't share a
common session and every execution starts a new connection using a
separate session.
When you run multiple query statements at the same time, and one
of the queries results in an error, then the whole query is cancelled.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-26 UTC."],[[["\u003cp\u003eAlloyDB Studio, accessible via the Google Cloud console, provides a unified interface to explore and manage your AlloyDB for PostgreSQL data, including a query editor and results table.\u003c/p\u003e\n"],["\u003cp\u003eThe Explorer pane within AlloyDB Studio allows users to create, alter, and delete various database objects like schemas, tables, columns, indexes, and functions, among others.\u003c/p\u003e\n"],["\u003cp\u003eTo access AlloyDB Studio, you need specific permissions, such as \u003ccode\u003ealloydb.clusters.get\u003c/code\u003e and \u003ccode\u003ealloydb.instances.executeSql\u003c/code\u003e, which can be granted through predefined or custom roles, along with necessary database-level permissions.\u003c/p\u003e\n"],["\u003cp\u003eUsers can compose SQL queries directly in the query editor or use templates provided for specific database actions, then run these queries and view the results in the Results table.\u003c/p\u003e\n"],["\u003cp\u003eAlloyDB Studio is subject to some limitations, including support for lightweight queries only, responses over 10MB being truncated, no persistent connections or shared sessions between editor tabs, and only supporting username and password authentication.\u003c/p\u003e\n"]]],[],null,["# Manage your data using the Google Cloud console\n\nThis page explains how to explore and manage your AlloyDB for PostgreSQL data\nusing AlloyDB Studio in the Google Cloud console.\n\nAlloyDB Studio includes an **Explorer** pane that\nintegrates with a query editor and a SQL query results table.\nYou can run DDL, DML, and DQL statements from this single interface. For\nexample, instead of configuring a third-party database query tool, you can\ncreate a table or query your data using this query editor.\n\nIf you're new to AlloyDB for PostgreSQL, see\n[AlloyDB overview](/alloydb/docs/overview).\n\nYou can use the **Explorer** pane in AlloyDB Studio to view and interact\nwith your database objects. You can create, alter, and delete the following\ndatabase objects:\n\n- Schemas\n- Tables\n- Columns\n- Indexes and keys\n- Triggers\n- Views\n- Functions\n- Procedures\n- Sequences\n- Types\n- Extensions\n\nRequired roles and permissions\n------------------------------\n\n\n| **Caution:** Users with broad database access could experience data loss when using Gemini. We recommend that you use an account with fewer database privileges when using Gemini.\n\n\u003cbr /\u003e\n\nTo use AlloyDB Studio, you need the following permissions:\n\n- `alloydb.clusters.get`\n- `alloydb.databases.list`\n- `alloydb.instances.executeSql`\n- `alloydb.instances.list`\n- `alloydb.users.list`\n\nYou can get these permissions through the\n[`roles/alloydb.admin`](/alloydb/docs/reference/iam-roles-permissions#roles)\nrole, or using a combination of\n[`roles/alloydb.viewer`](/alloydb/docs/reference/iam-roles-permissions#roles)\nand\n[`roles/alloydb.databaseUser`](/alloydb/docs/reference/iam-roles-permissions#roles)\nroles. If you don't have these roles, contact your Organization Administrator to\nrequest access. You might also be able to get the required permissions through\n[custom roles](/iam/docs/creating-custom-roles) or other\n[predefined roles](/iam/docs/understanding-roles).\n\nAdditionally, ensure that\nyou have [database-level permissions](/alloydb/docs/database-users/about)\nfor the database that you use for authentication.\n\nChoose a database authentication method\n---------------------------------------\n\nBefore you can access a database in AlloyDB Studio, you must first select a\ndatabase authentication method. To sign in to your database using\nAlloyDB Studio, you can use one of the following types of authentication:\n\n- IAM database authentication: use IAM\n authentication to manage the database access and privileges for users in your\n organization. To use this, set up\n [IAM authentication](/alloydb/docs/database-users/manage-iam-auth)\n on the instance.\n\n- Built-in database authentication: connect to the database in\n AlloyDB Studio by using your PostgreSQL user account and credentials. For\n more information, see\n [Manage PostgreSQL users with built-in authentication](/alloydb/docs/database-users/manage-roles).\n\nExplore your data\n-----------------\n\nTo access the **Explorer** pane, follow these steps:\n\n1. In the Google Cloud console, open the **AlloyDB** page.\n\n [Go to AlloyDB](https://console.cloud.google.com/alloydb)\n2. Select a cluster from the list.\n\n3. In the navigation menu, click **AlloyDB Studio**.\n\n4. Select a [database authentication method](#authentication).\n\n5. Click **Authenticate** . The **Explorer** pane displays a list of the objects\n in your database.\n\nCreate, modify, and query your data\n-----------------------------------\n\nYou can use the query editor to run SQL statements. Statements must be separated\nby a semicolon. Compose a query yourself, or populate the query editor with a\ntemplate.\n\nStatement execution is based on the order in which you enter them in the query\neditor.\n\nTo create, query, or modify your data, follow these steps:\n\n1. In the Google Cloud console, open the **AlloyDB** page.\n\n [Go to AlloyDB](https://console.cloud.google.com/alloydb)\n2. Select a cluster from the list.\n\n3. In the navigation menu, click **AlloyDB Studio**.\n\n4. Sign in to AlloyDB Studio using the name of your database, username,\n and password.\n\n5. Compose a query using one of the following methods:\n\n - To compose your own query, follow these steps:\n\n 1. Click add **New SQL editor tab** or add **New tab** to open a new tab.\n 2. When the query editor appears, write your query.\n - To compose a query that starts with a template, follow these steps:\n\n 1. In the **Explorer** pane, next to a database object, click more_vert **View actions**. One or more available actions appear.\n 2. Click an action. The query editor populates with a template.\n 3. Replace any placeholders in the template.\n6. Click **Run** . This executes all the queries in the query editor. The\n results of your query appear in the **Results** table.\n\n You can also select and execute one or multiple queries at the same time.\n To do this, select a query or multiple queries and click **Run selected**.\n\nLimitations\n-----------\n\n- AlloyDB Studio supports lightweight queries. Responses over 10MB might be truncated. AlloyDB Studio indicates when it returns partial results.\n- Long-running queries or index creations on large tables that exceed five minutes on the instance are timed-out and cancelled.\n- AlloyDB Studio doesn't keep a database connection open after execution of a SQL script is complete. Similarly, the **Editor** tabs don't share a common session and every execution starts a new connection using a separate session.\n- When you run multiple query statements at the same time, and one of the queries results in an error, then the whole query is cancelled.\n\nWhat's next\n-----------\n\n- Learn more about how [Gemini can help you write SQL or analyze your data](/alloydb/docs/write-sql-gemini)."]]
