Remote Database Manager with Visual ER Diagram for MySQL & MS-SQL

Amr Ewis — Mon, 03 Nov 2025 23:50:05 +0000

True story...

One-day i needed to check the database with phpMyAdmin but i was just have SSH access with no cPanel access, so i looked for a tool to fix this situation and i decided to build PHP script to be alternative for PhpMyAdmin.

The main target was Managing remote databases to be visualize with easy-to-access data, with visual diagram for fun 😅

Switching between tools, exporting/importing tables, execute SQL queries, making backups, keeping environments in sync — it takes time, attention, and patience.

So I built something that solves these pains with some fun added later.

Medians Database Manager

The beginning was to build tool to manage remote databases, generate later i figured some helpful tools while am building the project with Laravel.

First the ER Diagram which made it at another level to visualize and control the database remotely.

Migration files manually was a headache, so i added a feature to generate Laravel Migrations files considering the Indexes and tables relations.

Prisma schemas added by for the frontend developers too — all in one clean dashboard.

Live demo & features: https://mediansdb.site/

- Why I Built It

As developers we often need to:

-- Connect to remote DB servers (AWS / Digital-Ocean / Shared Hosting)
-- Backup & restore safely
-- Sync DB structure across environments
-- Generate migrations or schema files from existing DBs
-- Visualize DB relationships
-- Quickly test queries
-- Avoid risky command-line mistakes on production 😬

So I combined all the things I wished existed into one platform.

Key Features

Remote DB Access & Management

Supports MySQL, PostgreSQL & SQL Server
Add servers, browse DBs, run SQL, monitor queries.

-- Backup & Restore (1-Click)

Full or partial DB backup
Store online or download locally
Instant restore when needed

-- Visual ER Diagram Builder

Drag & drop schema editor
Manage relationships
Auto-layout & export

-- Generate Prisma Schema Automatically

From existing database ➜ to Prisma schema
Includes: ( Relations - Indexes - Comments - Optimization - options - comments )

Validation and direct file download

-- SQL Query Editor

Execute queries safely with history logs.

-- Schema Files Manager

Export, manage, and re-import SQL schema snapshots.

🧑‍💻 Who Will Love This? This tool helps ( Backend engineers - Laravel developers - Prisma users - SaaS founders - Database architects - DevOps & DB admins Especially if you manage remote production DBs or multi-environment systems)

🏁 Try It Free

🔗 Live site: https://mediansdb.site/

-- Free plan available
Explore backups, migrations, ERD tools & more

Feedback Welcome!

I'm improving this tool continuously, and I would love your feedback 🙌

Drop your thoughts below 👇 or DM me anytime.

Happy coding! 🧠💡🔥

DEV Community: Amr Ewis