Feature Reference

ENUK

Quick lookup for every button, field, toggle, and UI element in SQL Cor. For detailed explanations see User Guide and Admin Guide.

---

How to use this document

Use Ctrl+F (or Obsidian search) to find a specific element by name. Each entry answers: what it is · where it lives · what it does · what happens.

---

SQL Terminal page

Header elements

Element	Location	What it does	Notes
Administration	Header → right	Opens Administration panel	Visible to SysAdmin only. Query preserved on switch.
Theme toggle	Header → right	Switches Dark / Light theme	Saved in localStorage. Per-device preference.
Language button	Header → right	Switches UI language UKR ↔ ENG	Applies instantly. Does not affect DB content.
About button	Header → right	Opens ABOUT modal	Shows version, features, contacts. Close: click outside or Esc.

---

ABOUT modal

i

Note Opened via ℹ️ button in header

Element	What it shows
Version	Installed SQL Cor package version
Features list	Secure access · Audit trail · Role-based access control
Contact info	Support contact details
Close	Click outside modal or press Escape

---

Toolbar elements

Element	Shortcut	What it does	Behavior
Execute	F5 / Ctrl+Enter / Cmd+Enter	Runs the SQL in the editor	Blocked by: blacklist, wrong access level, maintenance mode
Clear	—	Empties editor, returns focus	Does NOT clear results or footer stats
Dry Run	—	Toggles safe-test mode ON/OFF	Highlighted when ON. Runs query in transaction → always ROLLBACK.
DB indicator	—	Shows connected database name	Display only. Not clickable. Example: Production_DB_Main

---

Editor elements

Feature	What it does	Detail
Line numbers	Displayed left of editor	Auto-updates as you type
Syntax highlighting	Colors SQL keywords, strings, comments, numbers	Keywords: cyan · Strings: orange · Comments: gray · Numbers: green
Tab indentation	Tab key inserts indent	For multi-line query formatting
Autosave	Saves query to localStorage as you type	Restored on page refresh. Last query preserved.
Undo / Redo	Ctrl+Z / Ctrl+Y	Standard editor undo/redo
Comment line	Ctrl+/	Adds/removes -- comment prefix
Select all	Ctrl+A	Selects all editor content
Multi-statement	Separate with ;	Executes in sequence. ReadOnly users: rejected if multiple statements detected.

---

Smart Hints bar

i

Note Yellow bar above results. Appears automatically after certain errors.

Hint	Trigger	Has INSERT button?
Case-sensitive names	Error: “relation X does not exist”	✅ Yes — rewrites query with quoted table name
TOP vs LIMIT	Query contains SELECT TOP N	✅ Yes — converts to SELECT ... LIMIT N
Permission error	DB-level “permission denied”	❌ No — informational only
Ambiguous column	Error: “column X is ambiguous”	✅ Yes — adds table alias to query

INSERT INTO EDITOR button: Replaces your current query with a corrected template. One click — no copy-paste needed.

---

Results panel elements

Element	What it does	Detail
Data table	Displays SELECT results	NULL=italic, TRUE=green, FALSE=red, numbers=right-aligned
Row count	Shows result size and duration	SELECT: “X rows returned in Y ms” · DML: “X rows changed in Y ms”
Row limit notice	Appears when results are truncated	”Results limited to X rows. Use LIMIT for precise control.”
Export button	📥 Downloads results as CSV	Only available after successful SELECT. Filename: sqlcor_export_YYYYMMDD_HHMMSS.csv

---

Footer elements (Status bar)

Indicator	Icon	What it shows	Updates when
Connection status	🟢/🔴/🟡	Database reachability: Connected / Disconnected / Checking	After each query; after Check Connection
Latency	—	Last query execution time in ms	After each query execution
Memory	Mem %	Browser JS heap memory usage	Continuously
Session timer	Session	Time since Terminal was opened (HH:MM:SS)	Every second. Resets on refresh/logout.

---

Dialogs — Terminal page

Destructive Operation confirmation

!

Warning Appears for DELETE queries when Dry Run is OFF

Property	Value
Trigger	Query contains DELETE + Dry Run is OFF
Purpose	Mandatory confirmation before permanent deletion
Shows	Warning message + preview of query

Button	Action
Confirm	Executes the DELETE query
Cancel	Closes dialog. Query NOT executed. Editor unchanged.

---

Administration page

Sidebar navigation

Item	Tab it opens
Access Control (Контроль доступу)	Admin Guide
Blacklist (Чорний список)	Admin Guide
Execution Logs (Журнал виконання)	Admin Guide
System Settings (Системні налаштування)	Admin Guide

Active tab: highlighted with colored accent bar on right edge.

---

Tab: Access Control

Statistics cards

Card	Shows
Active rules	Count of currently active rules
Users	Count of individual users with access
Roles	Count of roles with access

Filter bar

Filter	Options
Search	Name or email text search
Category	ReadOnly / DML / DDL
Type	User / Group (Role)
Status	Active / Revoked

Access rules table columns

Column	Shows
Subject	Avatar + Name + Email
Type	User or Group
Category	ReadOnly / DML / DDL
Status	Active (green) or Revoked (gray)
Valid Until	Date or ”—” (permanent)
Actions	Buttons (context-dependent)

Action buttons per rule

Rule state	Available buttons
Active rule	🚫 Revoke · 🗑️ Delete
Revoked rule	✏️ Edit (with Activate inside) · 🗑️ Delete

Button	What it does
Revoke 🚫	Deactivates rule. Status → Revoked. User loses access immediately. Record stays for audit.
Edit ✏️	Opens dialog pre-filled. Change dates/level. Has Activate button to re-enable.
Delete 🗑️	Permanently removes record from DB. Cannot be undone.

Grant Access dialog fields

Field	Type	Required	Description
Subject type	Radio: User / Role	✅	Who the rule applies to
User/Role	Dropdown (dynamic)	✅	Search by name. Loads based on Subject type.
Access Level	Radio: ReadOnly / DML / DDL	✅	What operations are permitted
Valid Until	Date picker	❌	Empty = permanent. Date = auto-expires.
Comment	Text input	❌	Reason for granting. Shown in audit trail.

Button	Action
Save	Creates rule immediately. Access granted instantly.
Cancel	Closes dialog. No changes made.

---

Tab: Blacklist

Statistics cards

Card	Icon	Shows
System limits	🔒 Cube	Built-in hardcoded rules (cannot be changed)
Manual rules	👤 User	Admin-created rules
Total	📊 Layers	All active entries combined

Blacklist table columns

Column	Shows
Icon	Object type (table / field / keyword)
Name	Pattern or value
Source	System 🔒 or Manual
Type	Table / Field / Keyword
Reason	Description shown to users on block
Actions	Edit / Delete (System rules: no buttons)

§

Important System rules (🔒) have NO action buttons. They cannot be edited or deleted.

Add Rule dialog fields

Field	Type	Required	Description
Record type	Radio: Table / Field / Keyword	✅	What kind of pattern to block
Value	Text input	✅	The name to block (e.g. SysUser, Account.SecretKey, DROP)
Description	Text input	❌	Message shown to users when their query is blocked

Button	Action
Save	Creates rule. Active immediately.
Cancel	Closes dialog. No changes.

---

Tab: Execution Logs

Filter controls

Control	Type	Options
Search	Text	Query text, username, status
From	Date picker	Start of time range
To	Date picker	End of time range
Day	Quick preset button	Last 24 hours
Week	Quick preset button	Last 7 days
Month	Quick preset button	Last 30 days

Log table columns

Column	Shows
Time	Timestamp (local timezone)
User	Creatio username
Query	Truncated query text (~60 chars)
Duration	Execution time in ms
Rows	Rows returned or affected
Status	Success 🟢 / Error 🔴 / Syntax ⚠️

Pagination: 50 records per page. Full server-side pagination.

Query Detail popup

Opened by clicking any row in the log table.

Element	Shows
Metadata	User · timestamp · duration · row count · status
Error text	Red text, if Status = Error
Full query	Complete query with syntax highlighting
Copy button	Copies full query to clipboard

---

Tab: System Settings

System Information block (read-only)

Field	Shows
Package version	Installed SQL Cor version
DBMS	PostgreSQL or MSSQL
Active rules	Count of active access rules
DB ping latency	Round-trip time to database in ms

Sliders

Slider	Key	Range	Default	Effect
Query Timeout	DnSqlDefaultTimeout	5s — 300s	30s	Max time before query is killed
Log Retention	DnSqlLogRetentionDays	0 — 365 days	90 days	How long audit logs are kept
Max Rows	DnSqlMaxRowLimit	100 — 10,000	1,000	Max rows per SELECT. Auto-injected as LIMIT.

Changes apply immediately. No Save button needed.

Feature toggles

Toggle	Effect when ON
Auto-Abort Heavy Queries	Kills queries consuming >1GB RAM

Maintenance Mode

Element	Description
Toggle	Large ON/OFF switch
Indicator	INACTIVE (gray) or ACTIVE (yellow)
Custom message field	Text shown to users when they try to execute during maintenance
Effect when ACTIVE	All non-SysAdmin users cannot execute queries
SysAdmins affected?	No — they can still execute queries
Auto-expires?	No — must be turned OFF manually

Service Actions

Button	What it does	Toast result
Check Connection	Pings database	🟢 “Database connection established (X ms)” or 🔴 “No database connection”
Check Access Level	Verifies current admin role	Toast showing current role and access level
Clear Logs	Bulk-deletes ALL audit log records	Requires confirmation · 🟢 “Deleted: X records”

×

Danger Clear Logs

Permanently deletes the entire audit history. Irreversible. Confirmation required.

---

Access level comparison

Operation	ReadOnly (10)	DML (20)	DDL (30)
SELECT	✅	✅	✅
INSERT	❌	✅	✅
UPDATE	❌	✅	✅
DELETE	❌	✅	✅
CREATE TABLE	❌	❌	✅
ALTER TABLE	❌	❌	✅
DROP TABLE (non-system)	❌	❌	✅
Auto-LIMIT injection	✅	➖	➖
Multi-statement block	✅ blocked	➖	➖
Hardcoded blocks	❌ always	❌ always	❌ always
Blacklist rules	❌ blocked	❌ blocked	❌ blocked
DnSql* table protection	❌ blocked	❌ blocked	❌ blocked

---

Security features summary

Feature	Where configured	Who can override
Access level check	Access Control tab	Admin
Blacklist (manual rules)	Blacklist tab	Admin
Hardcoded blacklist	Backend (DnSqlQueryParser.cs)	Nobody
DnSql* table protection	Backend	Nobody
Multi-statement block (ReadOnly)	Backend	Nobody
LIMIT/TOP auto-injection	Backend	Nobody
Literal masking	Backend	Nobody
Destructive operation dialog	Frontend	User (can confirm)
Maintenance mode	System Settings	Admin
Audit logging	Backend	Admin (Clear Logs only)

---

Quick navigation

I want to…	Go to
Run a query	User Guide
Export results	User Guide
Test a DELETE safely	User Guide
Grant someone access	Admin Guide
Block a table or keyword	Admin Guide
Review query history	Admin Guide
Enable maintenance mode	Admin Guide
Clear all logs	Admin Guide
Find keyboard shortcuts	Keyboard Shortcuts
Understand an error message	Message Reference
Fix a common problem	Troubleshooting

---

SQL Cor — Secure SQL Workbench for Creatio. Free and open source. License: MIT.

Document v1.0 · Applies to SQL Cor v1.0 · Last updated 1 June 2026