MySQL 8.0 · PostgreSQL and MariaDB coming soon

Databases
without the command line

Create databases, manage users and access permissions right from the panel. phpMyAdmin in one click.

Try for free All features

All your databases in one place

Create and delete databases, link them to sites, configure backups — without a single SQL command.

production-web-01 — Databases
app_production
MySQL 8.0 · 245 MB · 3 users
blog_production
MySQL 8.0 · 82 MB · 1 user
crm_production
MySQL 8.0 · 156 MB · 2 users
staging_db
MySQL 8.0 · 94 MB · 1 user
Users and permissions

Granular access permissions

Create database users, set passwords, configure full access or read-only. Manage remote access for each user.

  • Create users with secure passwords
  • Full access or read-only (SELECT only)
  • Grant and revoke privileges from the panel
  • Per-user remote access configuration
Database users
app_production · MySQL 8.0
app_user
Host: localhost
Full access Local only
app_readonly
Host: localhost
Read-only Local only
analytics_user
Host: 10.0.0.5
Read-only Remote
phpMyAdmin
Installed
pma.demo.deploykin.com
phpMyAdmin 5.2 · Auto-login
SSL
Let's Encrypt
Basic Auth
Enabled
Auto-login
Password-free login via the Deploykin panel
Basic Authentication
Extra password protection
phpMyAdmin

phpMyAdmin in one click

Install phpMyAdmin as a site template. Auto-login via the Deploykin panel, Basic Auth for extra protection, SSL automatically.

  • Install as a 1-click site template
  • Auto-login integration with Deploykin
  • Basic Auth protection against unauthorized access
  • SSL certificate issued automatically
Site integration

Automatic .env updates

Link a database to a site — Deploykin automatically updates DB_HOST, DB_DATABASE, DB_USERNAME and DB_PASSWORD in the .env file.

  • Auto-update .env when linking a database to a site
  • DB_HOST, DB_DATABASE, DB_USERNAME, DB_PASSWORD
  • No manual config edits
Linking a database to a site
demo.deploykin.com
Laravel
app_production
MySQL 8.0
.env updated automatically
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_DATABASE=app_production
DB_USERNAME=app_user
DB_PASSWORD=********

Scheduled backups for every database

Set up automatic backups for each database individually. Daily, weekly or monthly.

Backup schedule
app_production
Daily, 03:00
success
blog_production
Weekly, Mon 04:00
success
analytics
Daily, 02:00
success
crm_production
Daily, 03:30
failed

All database features

A complete toolkit for managing your data.

MySQL 8.0

Full MySQL 8.0 support with database creation and deletion from the UI.

PostgreSQL (soon)

PostgreSQL support for projects that need advanced functionality.

User management

Create users, set passwords, grant and revoke privileges.

Read-only access

Granular permissions: full access or SELECT-only for analytics.

Remote access

Configure remote access for each user individually.

phpMyAdmin

1-click installation with auto-login and Basic Auth protection.

Auto .env

Automatic .env updates when linking a database to a site.

Scheduled backups

Automatic scheduled backups for every database.

Delete from the UI

Safe deletion of databases and users through the panel.

MySQL dashboard

Real-time stats: active queries, connections, buffer pool, query cache.

Terminate process

Terminate stuck queries in one click from the panel, no SSH.

MariaDB (soon)

MariaDB support as a MySQL alternative with advanced capabilities.

System schemas

Manage can_access_system_schemas for each database user.

MySQL dashboard

Real-time database statistics

Active queries, connections, buffer pool usage, query cache — all MySQL health information right in the panel.

production-web-01 — MySQL dashboard
Live
Active queries
12
3 slow queries
Connections
45/150
30% used
Buffer Pool
67%
Query Cache
94%
cache hits
Process list
Updated 2 sec ago
PID User Database Query Time State
1847 app_user app_production SELECT * FROM orders WHERE created_at > ... 0.02s Executing
1853 app_user app_production UPDATE users SET last_login = NOW() WHERE ... 0.01s Updating
1901 analytics_user analytics SELECT COUNT(*) FROM events GROUP BY date... 12.4s Sending data
1923 app_user crm_production INSERT INTO activity_log (user_id, action... 0.00s Executing
1956 app_readonly app_production SELECT p.*, c.name FROM products p JOIN ... 34.7s Sorting result
1978 app_user blog_production SELECT posts.*, users.name FROM posts JO... 0.15s Executing
Terminate process

Terminate stuck queries from the panel

No more connecting over SSH and running KILL manually. Find the slow query in the process list and terminate it in one click.

  • Instant termination of stuck queries
  • Slow query highlighting (> 10 sec)
  • Full query text, duration and status
  • No SSH, no console, no KILL commands
Slow query detected
PID 1956 · app_production
34.7s
Query
SELECT p.*, c.name, c.email
FROM products p
JOIN categories c ON p.cat_id = c.id
WHERE p.status = 'active'
ORDER BY p.created_at DESC
User
app_readonly
State
Sorting result
Rows scanned
1,247,893
Supported engines
MySQL 8.0
v8.0.36
Installed
The main engine for most projects
MariaDB 10.11
v10.11
Soon
A MySQL fork with additional functionality
PostgreSQL 15
v15
Soon
Advanced data types, JSON, full-text search
Database engines

Database engines

MySQL 8.0 is currently fully supported. PostgreSQL and MariaDB — in development and coming in upcoming updates.

  • MySQL 8.0 — full support, dashboard, user management
  • MariaDB — soon
  • PostgreSQL — soon
Database on a separate server

Move the database to a dedicated server

Keep your application and database on different servers. Deploykin connects a site to MySQL on a dedicated database server and opens access only to the project's servers — the firewall is configured automatically.

  • Connect a site to MySQL on another server
  • The firewall automatically allows only the project's servers
  • .env is updated with the host, port and credentials automatically
  • Scale your application and database independently
Shop project
web-01 app
worker-01 app
:3306
db-01 MySQL
Firewall db-01: port 3306 is open only to web-01 and worker-01.
System schema access

Control access to system schemas

Configure can_access_system_schemas for each user. Allow or deny access to information_schema, mysql, performance_schema.

  • Granular per-user management
  • information_schema, mysql, performance_schema
  • Deny metadata access for regular users
  • Improved security in multi-tenant environments
System schemas
app_production · MySQL 8.0
app_user
information_schema
mysql
performance_schema
app_readonly
information_schema
mysql
performance_schema
analytics_user
information_schema
mysql
performance_schema
A green dot means access allowed, gray means denied

Tools for working with MySQL

Migration, cloning and size tracking — without manual export-import through the console.

SQL file import

Upload a dump through the panel — Deploykin imports it into the chosen database with no console.

Database cloning

Copy a whole database — including together with a site and even to another server in the project.

Database sizes

The size of each database is tracked automatically — you can see what's growing and using disk.

Redis

Redis for cache and queues

Install Redis on a server in one click, edit the config from the panel and open access between the project's servers — the firewall configures itself.

  • Install Redis as a service on the server
  • Redis configuration editor from the panel
  • Bind and firewall for the right network
  • Redis access between servers of the same project
redis.conf — db-01 
# bind — только приватная сеть проекта
bind 10.0.0.5
port 6379
maxmemory 512mb
maxmemory-policy allkeys-lru
appendonly yes

Manage databases without SQL

Create databases and users and configure permissions — all from the panel, without the command line.

Try for free Security

We use cookies and the Yandex Metrica web-analytics service (including Session Replay) to improve the site. Details are in the privacy policy.