🚀 Autobase 2.7 — SQL Editor

This release brings a SQL editor directly into the Autobase console, along with automated index maintenance to keep your databases performing at their best without manual intervention.

✨ Highlights

SQL Editor

In partnership with Zexa Technologies, we have integrated DBDesk Studio as an embedded SQL editor into our UI console. You can now connect to your clusters, run queries, and manage data directly from the console — all in one place.

Automated index maintenance

Now your indexes are always under control. With built-in automation powered by pg_auto_reindexer, Autobase continuously monitors and maintains index health, preventing bloat and performance degradation before it becomes a problem.

New Cloud regions

Added 24 new regions across AWS, GCP, Azure, and DigitalOcean to expand deployment options.

Multi-platform docker images

Added ARM support for Autobase Console Docker images, expanding compatibility across modern infrastructure.

What's Changed

• Add Patroni DCS failsafe_mode support by @Copilot in #1470
• Document minimum resources for testing and cap PostgreSQL memory in molecule tests by @Copilot in #1472
• chore(deps): update npm dependencies by @renovate[bot] in #1475
• chore(deps): update python dependencies by @renovate[bot] in #1476
• fix(deps): update go dependencies by @renovate[bot] in #1477
• fix(upgrade): restart all PgBouncer processes by @vitabaks in #1478
• Add SSH port field to “Your Own Machines” form by @Copilot in #1471
• Enable Docker Buildx multi-platform image publishing (amd64 + arm64) by @Copilot in #1479
• Bump flatted from 3.4.0 to 3.4.2 in /console/ui by @dependabot[bot] in #1481
• chore(deps): update npm dependencies by @renovate[bot] in #1482
• fix(deps): update go dependencies by @renovate[bot] in #1483
• Automate PostgreSQL index maintenance by @vitabaks in #1484
• chore(deps): update dependency yaml to v2.8.3 [security] by @renovate[bot] in #1487
• Bump picomatch from 4.0.3 to 4.0.4 in /console/ui by @dependabot[bot] in #1488
• fix: quote passwords in patroni.yml.j2 to prevent YAML type coercion by @MetalBlueberry in #1491
• register patroni service when dcs is consul by @evgeny-bushuev-incountry in #1494
• Make postgresql_index_maintenance a dict by @vitabaks in #1495
• Fix mount role crash when mount: [] (empty list) by @Copilot in #1497
• fix: Exclude the Patroni reload handler during setup to prevent bootstrap crash-loop on re-deploy by @MetalBlueberry in #1489
• Update confd to v0.33.1 by @vitabaks in #1498
• feat: Integrate DBDesk into the console for SQL editor functionality by @Anurag607 in #1463
• Console (API): Add missing cloud regions by @vitabaks in #1499
• Console (UI): Make the header and sidebar more compact by @vitabaks in #1500
• Console (UI): Update SQL Editor icon and reorder sidebar by @vitabaks in #1501
• fix: strip quotes when reading passwords back from patroni.yml by @MetalBlueberry in #1502

New Contributors

• @MetalBlueberry made their first contribution in #1491
• @Anurag607 made their first contribution in #1463

Full Changelog: 2.6.0...2.7.0