sqle
SQLE is an open-source SQL quality management platform supporting multiple database types (MySQL, PostgreSQL, Oracle, and Chinese national databases). It provides pre-deployment SQL auditing, post-deployment monitoring, and CI/CD integration to enforce SQL standards across the entire lifecycle.
Key facts
Objective fields from the source. Values we can't verify are shown as “Unknown” rather than guessed.
| Field | Value |
|---|---|
| Repository | actiontech/sqle |
| Owner | actiontech |
| Primary language | Go |
| License | MPL-2.0 — OSI-approved |
| Stars | 1.5k |
| Forks | 214 |
| Open issues | 195 |
| Latest release | v4.2606.0 (2026-07-03) |
| Last updated | 2026-07-03 |
| Source | https://github.com/actiontech/sqle |
What sqle is
Go-based platform offering SQL parsing, rule-based auditing (1000+ built-in rules), execution plan analysis, slow query detection, change versioning, and rollback capabilities. Integrates with Jenkins, IDEs (JetBrains), and messaging platforms (Feishu, DingTalk) for workflow automation.
Get the sqle source
Clone the repository and explore it locally.
git clone https://github.com/actiontech/sqle.gitcd sqle# follow the project's README for install & configurationNeed it deployed, integrated, or customized instead? DEV.co ships production installs.
Best use cases
Implementation considerations
- Requires Go runtime and database connectivity; Docker Compose deployment recommended for initial setup but source/RPM options available for production hardening.
- Rule library (1000+ rules) covers multiple scenarios (performance, security, compliance) but customization and tuning to organizational standards will be necessary.
- Integration with CI/CD (Jenkins) and messaging (Feishu, DingTalk) requires network access and credential management; plan for approvals workflow design.
- Change versioning and auto-generated rollback scripts depend on accurate schema detection; test thoroughly on target databases (especially less common versions of PostgreSQL, Oracle, Chinese DBs).
- Monitoring and slow-query collection require database-level access and potentially agent/probe deployment; coordinate with database and infrastructure teams.
When to avoid it — and what to weigh
- Lightweight single-database projects — Small teams with simple SQL workloads and no formal governance requirements; deployment and maintenance overhead likely exceeds value.
- Real-time query execution optimization only — If your primary need is live query performance tuning without audit/governance, specialized query optimizers or database profilers may be more efficient.
- Minimal English documentation tolerance — Primary documentation and UI are in Chinese; teams requiring full English documentation should evaluate translation burden and support availability.
- Air-gapped or highly restricted security environments — Requires careful vetting of dependencies and integration points; deployment model (community vs. enterprise) and network architecture must align with security policies.
License & commercial use
MPL-2.0 (Mozilla Public License 2.0)—a weak copyleft open-source license. Allows commercial use, modification, and private deployment. Requires preservation of copyright/license notices and disclosure of source modifications under MPL-2.0. Does not require downstream proprietary software to be open-sourced, but MPL-covered files must remain under MPL-2.0.
MPL-2.0 permits commercial use without explicit permission. However, the project distinguishes between Community Edition (implied OSS), Professional Edition (commercial evaluation via form), and Enterprise Edition. Commercial support and advanced features require engagement with ActionTech (vendor). Review the Community/Professional/Enterprise comparison and obtain proper license agreement before production deployment of non-community versions.
DEV.co evaluation signals
Editorial assessment — not user reviews. Directional, with an explicit confidence level.
| Signal | Assessment |
|---|---|
| Maintenance | Active |
| Documentation | Adequate |
| License clarity | Clear |
| Deployment complexity | Moderate |
| DEV.co fit | Good |
| Assessment confidence | High |
SQLE requires database credentials and direct access to parse/audit SQL and collect telemetry. No explicit security audit, vulnerability disclosure policy, or SOC2/ISO certification mentioned. Evaluate: credential storage (encryption, rotation), network isolation (especially for production databases), audit logging of SQLE admin actions, and compliance with organizational data residency/retention policies. Review dependency tree (Go modules) for supply-chain risk. Commercial support advisable for security-sensitive deployments.
Alternatives to consider
Aqua Data Studio / DBmarlin
Commercial tools with similar SQL auditing, execution plan analysis, and change management; vendor-backed support; may offer tighter IDE integration but higher license costs.
SonarQube (with SQL plugins) + custom scripting
Lightweight open-source approach using existing CI/CD ecosystems; less SQL-specific governance but flexible rule authoring; lower operational overhead for small teams.
Cloud database native auditing (AWS RDS Audit, Google Cloud Audit, Azure SQL Auditing)
If adopting cloud databases, built-in audit and compliance features reduce need for external platform; tighter integration but lock-in to cloud provider.
Build on sqle with DEV.co software developers
Start with the online demo (Community or Enterprise edition) to validate SQLE's audit rules and workflow against your database types and team processes. If multi-database governance and audit-trail compliance are priorities, engage ActionTech for Professional/Enterprise licensing and support consultation.
Talk to DEV.coRelated on DEV.co
Explore the category and the services that help you build with it.
sqle FAQ
Does SQLE replace manual code review or DBA approval?
Can SQLE scan existing production databases for non-compliant SQL?
What is the difference between Community, Professional, and Enterprise editions?
Does SQLE support databases outside the listed ones (MySQL, PostgreSQL, Oracle, Chinese DBs)?
Custom software development services
DEV.co helps companies turn open-source tools like sqle into production software. Our software development services cover the full lifecycle — architecture, web development, integration, and maintenance — delivered by software developers and web developers who ship. Engage our software development agency to implement or customize it for your open-source databases stack.
Evaluate SQLE for Your SQL Governance Needs
Start with the online demo (Community or Enterprise edition) to validate SQLE's audit rules and workflow against your database types and team processes. If multi-database governance and audit-trail compliance are priorities, engage ActionTech for Professional/Enterprise licensing and support consultation.