Access to DB with Web SQL Editor
Overview
QueryPie offers a web SQL editor, providing a convenient platform to execute queries and view data directly from a web browser. Upon logging into QueryPie, authorized users gain swift access to their permitted connections, streamlining the process of database interaction.
Access Granted Databases
You can view a comprehensive list of database connections authorized for individual users or groups. Simply select a connection from the list to initiate actions within the database.

Database Connections
Once logged into QueryPie, navigate to the Connections tab at the top.
On the left panel, you'll find a list of available database connections.
Click on the desired connection to view its details on the right side. Then, click the
Connect
button to establish a connection.
If the connection you require is not listed, you can request access through the DB Access Request feature.

Use the Web SQL Editor
.png?inst-v=b474c9ef-45d8-48cc-a68e-151030ff0cca)
SQL Editor
The editor interface comprises an Object Panel on the left, a Top Toolbar, a SQL Editor in the center, and an Object Info Panel on the right.
.png?inst-v=b474c9ef-45d8-48cc-a68e-151030ff0cca)
SQL Editor > Connection Panel
Change Connection : Use the arrow buttons on the left object panel to switch between the current connection and other available connections.
Disconnect : Click the
Disconnect
button to terminate the current connection.

SQL Editor > Object Panel
Change database : You have the option to switch to a different database from the one you are currently connected to.
※ Note that upon initial connection, you are typically connected to the default database.
Retrieve object information : You can retrieve details such as schemas, tables, views, events, functions, procedures, and triggers within the connected database.
Get Object Information : You can view details such as schemas, tables, views, events, functions, procedures, and triggers within the connected database.
Update object information : After selecting a specific schema, table, view, event, function, procedure, or trigger, you can refresh the object information by clicking the
Refresh
button on the right side. (Alternatively, for individual objects, you can reload them by right-clicking and selecting theReload Object
option.)

SQL Editor > Toolbar
Run SQL : Executes the query you've written. By default, the entire query is executed.
Stop : Halts the execution of the currently running query.
Object Panel : Toggles the visibility of the left object panel.
Open : Imports an SQL file.
Undo : Reverts the most recent change made to the query.
Redo : Reapplies the most recently undone operation.
Format SQL : Rearranges the formatting of the query.
Import : Imports data from an SQL, CSV, or Excel file and saves it to the database.
Export : Downloads data as an SQL, CSV, JSON, or Excel file.
SQL Request : Submits a query created in the editor as a SQL Request through Workflow.

SQL Editor > Editor Tab & Result
Supports autocomplete while constructing queries, accessible through the context menu or hotkeys.
Limit : Allows restricting the number of rows displayed in query results, defaulted to 1000.
Expand : Offers a full-screen view of the query execution results.
Stack/Column View : Facilitates viewing query results in a horizontally or vertically divided grid, suitable for multiple query execution scenarios.

SQL Editor > Object Info Panel
Data : Displays the data of a table or view object.
Structure : Allows checking the structure of a table or view object.
Index : Provides access to index information of a table.
Relation : Displays the connection relationship of the table.
Trigger : Shows trigger information.
Script : Displays the script information of an object.
Info : Provides detailed information about an object.
Is there a limit to the size of queries I can run in WebEditor?
For SQL Editor:
There is a limit of 10 million characters in a single query run.
It supports up to 9999 lines within the query editor.
The query editor allows files up to 5 MB in size.
When uploading files, files can be up to 5 MB in size.
For Workflow > SQL Request > When attaching a file:
Select the File type to run queries with file attachments without a query size limit.
A single query is limited to 10 million characters.
If you select Text, the query editor supports up to 9999 lines.
If you choose the Text type, the query editor supports file sizes up to 5 MB.
Related Topics