Skip to content

OpusCor/SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

2 Commits
Β 
Β 

Repository files navigation

[SQLCor]

A controlled SQL terminal for Creatio Cloud

Direct database access for administrators β€” safe, audited, in-platform.

Documentation Β· Status Β· Contact


The problem

Creatio Cloud administrators have no direct database access. The platform abstracts SQL away β€” which is fine for end users, but creates a daily bottleneck for admins who need to:

  • Investigate data inconsistencies
  • Audit configuration changes
  • Verify data after imports and migrations
  • Debug workflow and process issues
  • Run quick operational and reporting queries

Without direct access, a thirty-second query becomes a two-day support ticket, a tedious UI reconstruction, or a heavy export into Excel or Power BI. None of these scale.

What SQL Cor does

SQL Cor adds a controlled, audited SQL terminal directly inside Creatio. It gives administrators the database access the Cloud platform removes β€” without sacrificing security or traceability.

  • Direct SQL execution against the Creatio database (PostgreSQL or MSSQL)
  • Graded access control β€” Read-only / DML / DDL, assigned per user
  • Query blacklist β€” block dangerous patterns system-wide, regardless of role
  • Full audit log β€” every query logged with user, timestamp, result, and execution time
  • Safe defaults β€” automatic row-limit injection on SELECTs, configurable timeouts
  • Dry-run mode β€” preview affected rows before running a DML statement
  • Dark / light themes, English and Ukrainian
  • Administration page for managing access rules, blacklist entries, and viewing logs

Why it's built the way it is

The goal was never "give everyone raw database access." It was to give the right people the right level of access, with everything logged.

Layer What it does
Access control Only authorized users run queries. Permissions graded per user.
Query blacklist Dangerous patterns blocked at system level, above individual roles.
Audit log Every query recorded β€” who, when, what, how long.
Safe defaults Row limits, timeouts, dry-run previews to protect the environment.

Live demo

SQL Cor is currently running on a live, read-only demo environment as part of an open testing period.

Demo access (login credentials for a live Creatio instance) is shared through the beta announcement on LinkedIn β€” see Contact to connect.

For the full feature tour and documentation, visit sql.opuscor.com.

Status

🟑 In testing (beta).

SQL Cor is currently in a testing period. The application is stable and running on the live demo above.

The downloadable package is coming soon. After the testing period, SQL Cor will be published here for installation as a standard Creatio package.

A live read-only demo is available during the testing period β€” access is shared via the beta announcement on LinkedIn. If you'd like to try the demo, run SQL Cor in your own environment, or you have questions, reach out β€” see Contact.

Installation

Installation instructions will be published here when the downloadable package is released.

Full setup and configuration documentation is available now at sql.opuscor.com.

In short, once released: install as a standard Creatio package (drag-and-drop ZIP), configure access rules and blacklist on the administration page, and you're running. Self-contained, no external dependencies. Works on Creatio Cloud and on-premise.

Documentation

Complete documentation β€” user guide, administration guide, configuration reference β€” lives at:

πŸ‘‰ sql.opuscor.com

Contact

SQL Cor is built and maintained by Artem [Last Name], an independent Creatio specialist.

  • Questions, early access during testing, or installation help: reach out via LinkedIn
  • Available for Creatio implementation projects and consulting

License

License will be specified at public release.


[SQLCor] β€” SQL access for Creatio Cloud admins. Safe, audited, in-platform.

sql.opuscor.com

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors