Database Manager

The Database Manager provides a full-featured interface for managing your MySQL, MariaDB, and PostgreSQL databases without needing command-line tools or external applications.

Database Servers

The Databases page lists configured database servers. Each server shows:

• Name — Server identifier
• Type — MySQL, MariaDB, or PostgreSQL
• Host — Container name or external host
• Status — Connection status

Testing Connection

Click "Test Connection" to verify the database server is accessible. This checks:

• Network connectivity
• Authentication credentials
• Database server is running

Opening the Database Manager

Click on a database server to open the Database Manager. This provides a comprehensive interface with several sections:

Databases Panel

Left sidebar showing all databases on the server:

• Click a database to select it
• System databases are marked (information_schema, mysql, etc.)
• "New Database" button to create databases

Tables Panel

When a database is selected, shows all tables:

• Click a table to view its data
• Shows row count (estimated)
• Shows table size

Data Viewer

When a table is selected, displays its contents:

• Columns — Sortable table columns
• Pagination — Navigate large datasets
• Page Size — Rows per page
• Refresh — Reload data

Query Editor

Write and execute custom SQL queries:

• Syntax highlighting
• Execute button or Ctrl+Enter
• Results displayed in table format
• Error messages for failed queries

Database Operations

Create Database

1. Click "New Database" in the databases panel
2. Enter the database name
3. Select character set (optional)
4. Click "Create"

Delete Database

1. Right-click on a database (or use the menu)
2. Select "Delete"
3. Confirm the deletion

User Management

Manage database users and permissions:

View Users

Navigate to the Users tab to see all database users:

• Username and host
• Authentication method
• Granted privileges

Create User

1. Click "New User"
2. Enter username
3. Enter password
4. Set host (% for any host, localhost for local only)
5. Click "Create"

Grant Privileges

1. Select a user
2. Click "Grant Privileges"
3. Select the database
4. Choose privileges (ALL, SELECT, INSERT, etc.)
5. Click "Grant"

Common Tasks

Creating a Database for a New App

1. Open the Database Manager
2. Create a new database (e.g., "myapp_production")
3. Create a new user (e.g., "myapp_user")
4. Grant ALL privileges on the database to the user
5. Use the credentials in your application's config

Querying Data

1. Select the database
2. Open the Query Editor tab
3. Write your SQL query
4. Press Ctrl+Enter or click Execute
5. View results in the table below

-- Example queries
SELECT * FROM users WHERE created_at > '2024-01-01';

SELECT COUNT(*) as total, status
FROM orders
GROUP BY status;

SELECT u.name, COUNT(o.id) as order_count
FROM users u
LEFT JOIN orders o ON u.id = o.user_id
GROUP BY u.id;

Exporting Data

Use the Query Editor to export data:

1. Write a SELECT query for the data you want
2. Execute the query
3. Click "Export" above the results
4. Choose format (CSV, JSON)

Keyboard Shortcuts