Audax Data Manager

Overview

Audax Data Manager (formerly PgManage) is a modern, open-source SQL editor and database administration client designed for developers and database administrators. It supports multiple database engines including PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, and SQLite3. The tool emphasizes a clean, intuitive interface that stays out of the user's way while providing powerful features like schema editing, performance monitoring, backup management, and SSH tunneling. It is available as a desktop application for Linux, Windows, and macOS, with an Enterprise edition offering remote web access, multi-user support, and OAuth2 authentication.

Key Features

• Multi-Database Support: Connect to PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, and SQLite3 from a single interface.
• Modern Interface: Intuitive design with switchable themes and UI scaling for a personalized experience.
• Security & Privacy: Privacy-first approach with no data collection or telemetry; credentials are stored encrypted.
• Powerful Administration Tools: View database performance metrics, run backups, manage roles and extensions, tune PostgreSQL server parameters, and connect via SSH tunnels.
• Convenient Workspaces: Use multiple database workspaces simultaneously; edit data in a spreadsheet-like grid; fuzzy search for database objects; hotkeys and keyboard navigation.
• Smart SQL Editor: Schema- and context-aware autocomplete for tables, views, columns, aliases, and functions; inline query error annotations; export table data as Markdown, JSON, or CSV.
• Schema Editor: Visual schema editing with support for renaming indexes, updating column comments, and Oracle compatibility.
• Data Editor: Copy/paste cell regions, edit complex content in a modal window, full-screen mode for data editor and ERD tabs.
• Backup & Restore: Supports multiple versions of pg_dump/pg_restore binaries for version matching.
• Enterprise Edition: Adds remote web access, multi-user support, OAuth2 authentication, AWS and Docker deployment options.

Use Cases

• Database Administrators: Manage multiple database servers, monitor performance, handle backups, and tune PostgreSQL parameters from a single tool.
• Developers: Write and debug SQL queries with smart autocomplete, edit data directly, and visualize database schemas via ERD diagrams.
• DevOps Engineers: Use SSH tunneling for secure remote connections, deploy via Docker or AWS Marketplace, and integrate into CI/CD pipelines.
• Small to Medium Teams: The Enterprise edition enables collaborative database management with multi-user access and OAuth2 authentication.