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! 🧠💡🔥
Top comments (0)