Features

The full feature list, grouped the way the admin is grouped. Linked words open the in-depth guide.

• Database work
  • Data editor
    • Object tree across every connected database
    • Paginated browsing with sorting and per-column filters
    • Type-aware row editor to insert, update and delete
  • SQL console
    • Query editor with syntax highlighting
    • Runs one statement at a time
    • Query history of 50 entries per browser
    • Optional read-only mode
  • Structure editor
    • Columns, indexes and foreign keys
    • Preview the exact changes before applying them
    • Create, drop, rename and truncate tables
  • Export
    • SQL dumps, per table or whole database, with engine-correct quoting
    • CSV
  • Import
    • Multi-statement .sql files with per-statement error reporting
    • CSV into a single table
    • 32 MB limit on imports and uploads
• Connections and multi-database
  • The Joomla site database is always present
  • Attach MySQL/MariaDB, PostgreSQL and SQLite databases alongside it
  • Per-driver setup and options
  • Encrypted stored passwords
  • Live test before saving
• Access control and delegation
  • Profiles and ACL, native to Joomla
    • Scope connections, tables and operations
    • Assign to users or groups
    • Permission rules always enforced on the server, with no bypass from the browser
    • The "Bind to MySQL grants" option is reserved for a future release and has no effect yet
  • Delegated management without Super User
    • Per-area, per-action management grants
    • Strict no-escalation rules
• Audit
  • Audit trail to answer who changed what, and when
    • Before and after row snapshots
    • Best-effort recording
    • Credential redaction
    • Filtered log viewer
  • Audit policy to control what is kept
    • Global default with per-profile overrides
    • Retention
    • Scheduled pruning
• Frontend data views
  • Live, read-only query results on the site frontend, without granting backend access
  • Validated read-only SELECT
  • Build wizard
  • Per-visitor access control
  • Visitor experience
    • Toolbar and interactions
    • Auto-refresh
    • Printing
    • Phone layout
  • Search engine settings
• Security and settings
  • Core-table protection
    • Always on for the Joomla site database
    • On by default for attached connections
  • SQLite path allow-list
  • Audit redaction
  • Baseline web hardening
  • Settings for editor defaults and the security and audit configuration
• AI features (Coming soon)
  • MCP server to connect AI assistants such as Claude or ChatGPT, respecting your Joomla permissions
  • Agent Skills that teach AI assistants to set up, configure and troubleshoot Next DB
  • AI-ready documentation, such as an llms.txt index and plain Markdown pages
  • AI help inside Next DB for repetitive, everyday tasks