Better Databases vA1.0.5

THIS EXTENSION SUPPORTS BOTH STANDALONE AND BLUEPRINT INSTALLATIONS
THIS EXTENSION SUPPORTS BOTH STANDALONE AND BLUEPRINT INSTALLATIONS

Better Databases

Better Databases upgrades the normal Pterodactyl database page into a much more useful database management experience.

Instead of only creating MySQL databases and showing credentials, this addon lets your panel create and manage databases across multiple engines, with a cleaner user-facing interface and an admin provider system built for real hosting setups.

What It Adds

Better Databases lets you offer server databases from:

• MySQL / MariaDB
• PostgreSQL
• MongoDB
• Redis allocations, if enabled by the admin

Each provider can be configured from the admin area, so you can connect the panel to one or more database hosts and decide which engines are available to users.

User Features

Users can create database allocations from the normal server Databases page, then view and manage them directly inside the panel.

Depending on the database engine, users can:

• View connection details
• Rotate database passwords
• Browse database contents
• Inspect tables, columns, rows, and collections
• Search rows or documents
• Import and export databases
• Use SQL tools for supported SQL databases
• Access generated connection URLs
• Open a database directly from a shareable ?db= link

The addon keeps the experience inside the familiar Pterodactyl server page, so users do not need to jump between tools just to inspect a database.

Admin Features

Admins can add database providers for different engines and control what features are available.

Provider accounts are used only for provisioning. When users create databases, Better Databases generates tenant credentials for each database instead of reusing the provider account.

For example:

• MySQL creates a generated user for the generated database
• PostgreSQL creates a generated role that owns its generated database
• MongoDB creates a generated user with access only to its generated database

This keeps user-facing credentials separate from the provider credentials.

Installation

The addon is distributed as an AINX package.

If AINX is not installed yet:

npm i -g ainx