🚀 Features

🗄️ MySQL Administration

A complete MySQL database management module with an intuitive graphical interface.

Features

Create, load and delete databases
Create and delete tables
Add new columns dynamically
Insert, update and delete records
Multi-row delete support
Dynamic search and filtering
Execute custom SQL queries
View table data instantly
Database statistics dashboard
Report export
CSV Import / Export
JSON Backup / Restore

🍃 MongoDB Administration

Manage MongoDB databases and collections without writing commands.

Features

Connect using MongoDB Atlas or Local Server
Create databases
Create collections
Insert, update and delete documents
Delete fields from all documents
Dynamic document editor
Regex search
Collection statistics
CSV Import / Export
JSON Backup / Restore

🔄 Cross Database Migration

Transfer data seamlessly between SQL and NoSQL databases.

Supported

✅ MySQL → MongoDB
✅ MongoDB → MySQL

Features

Automatic Database Creation
Automatic Table / Collection Creation
Automatic Schema Detection
Automatic Data Type Mapping
Remove MongoDB _id while migrating to SQL
Replace Existing Data
Append New Data
Single Table Migration
Multi Table Migration
Single Collection Migration
Multi Collection Migration

📂 CSV Import / Export

Move data between databases and spreadsheets.

Export

Export any MySQL table to CSV
Export any MongoDB collection to CSV

Import

Automatically creates missing tables
Automatically creates missing columns
Imports thousands of records
Handles empty values safely

💾 JSON Backup & Restore

Complete database backup solution.

MySQL

Backup entire database
Backup all tables
Restore automatically
Creates database if missing
Creates tables automatically
Restores all records

MongoDB

Backup complete database
Backup all collections
Restore entire database
Replace existing collections
Restore documents automatically

📊 Analytics Dashboard

Visual database insights for MySQL.

Dashboard Includes

Total Tables
Total Records
Largest Table
Average Records
Database Size
Pie Chart Distribution
Bar Chart Analysis
Top Largest Tables
Export Analytics Report

📈 MongoDB Statistics

Collection level analytics.

Includes

Total Collections
Total Documents
Largest Collection
Average Documents
Database Size
Average Document Size
Total Indexes
Index Size
Top Largest Collections

🔍 Search & Filtering

Find data quickly across databases.

MySQL

Search records dynamically
Column-wise filtering

MongoDB

Regex based searching
Instant document filtering

⚡ SQL Query Executor

Execute SQL commands directly.

Supports

SELECT
INSERT
UPDATE
DELETE
CREATE
ALTER
DROP
Custom Queries

📄 Report Export

Generate analytics reports.

Supported

TXT Report
Analytics Summary
Database Statistics

🎨 User Interface

Modern desktop application built with Tkinter.

Highlights

Modern Dashboard
Responsive Layout
Separate MySQL & MongoDB Managers
Dynamic Forms
Editable Tables
Scrollable Views
Statistics Dashboard
Analytics Window
Backup Manager
Migration Manager

⚙️ Technologies Used

Python 3.10+
Tkinter
MySQL Connector
PyMongo
Matplotlib
Pandas
JSON
CSV
Requests
Pillow (PIL)
PyInstaller

⭐ Highlights

Dual Database Management (SQL + NoSQL)
Cross Database Migration
Automatic Schema Detection
Automatic Type Mapping
Backup & Restore
CSV Import / Export
Analytics Dashboard
MongoDB Statistics
Search & Filter
Report Generation
Beginner Friendly GUI
Modular Python Architecture