SQL Studio – an editor with auto-completion for table and column names, favorite queries

What this solution does

SQL Studio is a full-featured SQL query editor designed for the 1C-Bitrix administration panel. The tool allows executing queries directly within the system interface, eliminating the need to switch to external utilities like phpMyAdmin.

Key capabilities:

Table and column name auto-completion. As you type, the system suggests available options, supporting both core 1C-Bitrix tables and third-party module tables. This allows efficient work with the data structure without constant reference to documentation.

SQL syntax highlighting to improve code readability and editing.

SQL code is automatically formatted with syntax highlighting for keywords, table names, columns, and strings. This enhances readability and allows immediate detection of syntax errors, such as missing commas or extra quotes.

Inline data editing

After executing a SELECT query, you can modify values directly in the result grid. Clicking a cell triggers the module to automatically generate and execute the corresponding UPDATE query, eliminating the need to write code manually for quick corrections.

Protection against dangerous operations

Attempting to run DELETE or UPDATE statements without a WHERE clause triggers a red warning and requires user confirmation. A read-only mode is also available to completely block any data-modifying queries.

Query history

All executed queries are saved and can be searched or filtered by date, enabling quick retrieval of previously created complex reports.

Saved queries

Frequently used queries, including complex reports and utility checks, can be saved to favorites. The system supports up to 50 saved items, allowing any favorite query to be executed with a single click.

Result export

Query results can be exported to Excel, CSV, or JSON formats, facilitating the creation of reporting documentation. The module includes a collection of over 20 ready-made templates for popular SQL queries in 1C-Bitrix, such as searching for users with orders; users simply select a template, substitute parameters, and execute the query. An integrated formatting tool automatically converts SQL code into a readable format with correct indentation, eliminating issues with unstructured code. The system supports executing multiple queries either as a single batch command or individually. A read-only mode is available to restrict permissions to SELECT queries only, which is useful when granting access to junior developers or protecting against accidental data modifications. The interface features syntax highlighting, automatic saving of query history, fast performance within the 1C-Bitrix admin panel, auto-completion for table and column names, and inline editing of results. Additionally, query analysis via EXPLAIN is supported.

SQL Studio is a module for working with databases within the Bitrix administration panel. The tool provides auto-completion for table and column names, along with the ability to save favorite queries.

Site administrators can quickly retrieve data, verify records, and make changes without using external utilities like phpMyAdmin. Technical specialists gain a unified workspace for routine checks, report generation, and debugging. Features such as query history, favorites, and templates streamline the workflow.

The module is actively developed and supported. Users may report bugs or suggest enhancements. The developer personally uses all features of the tool on a daily basis, ensuring focus on in-demand capabilities while excluding unnecessary functions.

General iT can install and configure this module and check how it works on your website.