Connect via Web SQL Editor

Overview

QueryPie provides a web SQL editor that allows users to execute queries and retrieve data through a web browser.

You can view a list of database connections assigned to individual users or groups and select a connection to perform tasks and access the database.

After logging into QueryPie, click on Databases from the top menu bar.
Accessible database connections will be displayed in the left panel.
Click on the desired connection to see detailed information on the right and click the Connect button to access it.

If the required connection is not displayed, you can request access permission through Workflow > DB Access Request.

The editor consists of a left object panel, a top toolbar, a middle SQL editor, and a right object information panel.

Change connection: Use the arrow button to view and switch between connected connections.
Connection Management: Navigate to the Databases connection list while maintaining the current connection.
Disconnect: Click the disconnect button to disconnect the current connection.

Change database: Change the currently connected database (default database is connected initially).
Search object information: Search for schemas, tables, views, events, functions, procedures, and triggers in the database.
View object information: View schemas, tables, views, events, functions, procedures, and triggers in the database.
Refresh object information: Click the refresh button on the right when an object is selected to update the object information. For individual objects, right-click and click Reload Object to refresh.

Run SQL : Execute the written query. By default, the entire written query is executed.
Stop : Stop the currently executing query.
Object Panel : Option to toggle the left object panel.
Open : Load an SQL file.
Save : Save an SQL file.
Undo : Undo actions within the query.
Redo : Redo previously undone actions.
Format : Format the written query.
Auto commit : Automatically commit performed query operations.
- Commit : Manually commit performed query operations.
- List : List uncommitted queries.
- Rollback : Rollback to the stage right after the last commit.
Import : Import data from SQL/CSV/Excel files and store it in the database.
Export : Download data as SQL/CSV/JSON/Excel files.
SQL Request : Send the query written in the editor to the SQL Request workflow page.

Supports autocomplete while writing queries, and you can use context menus and shortcuts.
Limit: Limit the number of rows output when executing a query (default is 1000).
Full Screen : View query execution results in full screen.
Stack/Column View : View results in horizontally or vertically split grids when multiple queries are executed.

Queries : If Query Sharing is enabled, you can import/export SQL queries from/to a connected GitHub Repository.

To use this feature, the administrator must pre-configure query sharing settings (refer to General > Query Sharing Settings).

SQL History : View the history of executed queries, stored for up to 3 months.

Q: Is there a limit to the size of queries that can be executed in the web editor?

A: The SQL Editor supports the following:

A: In the Workflow > SQL Request screen, when attaching a file: