A comprehensive and integrated database management application that provides a visual interface for connecting to and managing multiple types of databases with a modern user interface and advanced features.
Omni Core DB Manager is a powerful database management tool that allows users to browse tables, view and edit data, execute custom queries, and easily import/export data. The application provides a robust and user-friendly experience for managing databases across SQLite, PostgreSQL, and MySQL databases.
- Multi-Database Support: Supports SQLite, PostgreSQL, and MySQL.
- Automatic Database Type Detection: Smart detection from file path or connection string.
- Test Connections: Verify connectivity to the database before saving.
- Manage Multiple Connections: Handle several database connections simultaneously.
| Feature | Description |
|---|---|
| View Tables | Display all tables with row and column counts. |
| Create Tables | Define new tables with columns, types, and constraints. |
| Rename Tables | Change the names of existing tables. |
| Delete Tables | Drop tables with confirmation. |
| Truncate Tables | Remove all data while preserving the table structure. |
| Analyze Tables | Get comprehensive statistics (rows, columns, indexes, foreign keys). |
- View Columns | Display column metadata including types, nullability, and default values.
- Add Columns | Add new columns to existing tables.
- Modify Columns | Change column properties (name, type, nullability, default value).
- Drop Columns | Remove columns from tables (for PostgreSQL/MySQL only).
- Browse Rows | View table data with pagination (20 rows per page).
- Insert Rows | Add new records to tables.
- Update Rows | Edit existing records.
- Delete Rows | Remove individual records.
- Search Rows | Filter data across text columns.
- Sort Rows | Order data by any column (ascending/descending).
- Execute Custom SQL Queries | Run any SQL query with syntax highlighting.
- Query History | Track all executed queries with timestamps and execution times.
- Clear Query History | Remove historical query data.
- Query Timing | Measure the execution time for each query.
- Bulk Insert | Insert multiple rows in a single operation.
- Bulk Update | Update multiple rows matching criteria.
- Bulk Delete | Delete multiple rows by a list of IDs.
- Export to JSON | Download table data as a JSON file.
- Export to CSV | Download table data as a CSV file.
- Export SQL Dump | Generate SQL statements for the entire database or specific tables.
- Import from JSON | Load data from JSON files.
- Import from CSV | Load data from CSV files with error reporting.
- Schema Inspection | Visualize the detailed table structure.
- Table Relationships | View foreign key relationships.
- Index Management | Create and manage database indexes.
- Constraint Management | Handle primary keys, foreign keys, unique, and
CHECKconstraints. - Saved Queries | Save frequently used queries with parameters and tags.
- Query Performance Analysis | Explain and analyze queries with detailed performance breakdown.
- Backup and Restore | Create and restore database backups in SQL or JSON format.
- Performance Monitoring | Track slow queries and real-time performance metrics.
- Data Validation | Define and enforce validation rules for data integrity.
- Dark/Light Mode | Toggle between modes with
localStoragepersistence. - 7 Theme Color Palettes | Customize your experience.
- Responsive Design | Works on all devices.
- Modern Animations | Smooth transitions and effects.
- Glassmorphism Effects | Beautiful interface design.
- Sound Effects | Interactive audio feedback.
- Resizable Panels | Adjustable side and content areas.
- Confirmation Dialogs | Safety checks for destructive operations.
- Toast Notifications | Real-time feedback for all operations.
| Technology | Description |
|---|---|
| React 18+ with TypeScript | The core library for building the user interface. |
| Vite | Fast build tool for development and production. |
| shadcn/ui | UI components (New York style). |
| Tailwind CSS | Utility-first CSS framework for styling. |
| TanStack Query | For server state management and data fetching. |
| Wouter | A small and simple routing library. |
| React Hook Form & Zod | For form handling and data validation. |
| Technology | Description |
|---|---|
| FastAPI with Uvicorn | High-performance Python framework for building the API. |
| SQLAlchemy | Database abstraction layer. |
| Pydantic | For data validation and settings management. |
| Database Support | SQLite, PostgreSQL, and MySQL. |
| Connection Storage | In-memory connection storage. |
| API | RESTful API with OpenAPI/Swagger documentation. |
Ensure you have the following installed:
- Node.js 20 or later
- Python 3.11 or later
- uv package manager (for Python)
-
Clone the repository:
git clone https://github.com/Alqudimi/OmniCoreDB.git cd OmniCoreDB -
Install Node.js dependencies:
npm install
-
Install Python dependencies:
uv sync
-
Run the development server:
npm run dev
This will start:
- The backend API at
http://localhost:8000 - The frontend at
http://localhost:5000
- The backend API at
-
Build the frontend:
npm run build
-
Start the production server:
npm run start
The application will be served on port
5000.
Comprehensive documentation is available in both English and Arabic.
- Main Guide - Complete overview and getting started
- Installation Guide - Detailed installation instructions
- User Guide - Comprehensive user manual
- API Reference - Full API documentation
- Developer Guide - Guide for development and contribution
- ุงูุฏููู ุงูุฑุฆูุณู - ูุธุฑุฉ ุนุงู ุฉ ูุฏููู ุงูุจุฏุก
- ุฏููู ุงูุชุซุจูุช - ุชุนููู ุงุช ุงูุชุซุจูุช ุงูุชูุตูููุฉ
- ุฏููู ุงูู ุณุชุฎุฏู - ุฏููู ุงูู ุณุชุฎุฏู ุงูุดุงู ู
- ู ุฑุฌุน API - ูุซุงุฆู API ุงููุงู ูุฉ
- ุฏููู ุงูู ุทูุฑ - ุฏููู ุงูุชุทููุฑ ูุงูู ุณุงูู ุฉ
- Full CRUD operations for tables, columns, and rows.
- Multi-database support with automatic detection.
- Advanced query execution with analysis.
- Bulk operations and data import/export.
- Backup and restore functionalities.
- Performance monitoring and data validation.
- Modern, responsive UI with themes.
- Schema comparison and synchronization.
- User management and role-based access control (RBAC).
- Validation enhancements and sanity checks.
- Collaboration features and connection sharing.
- Data visualization and dashboard builder.
- Automated testing and CI/CD integration.
- Advanced query features and optimization.
- Backup scheduling and management.
- Data migration tools between databases.
The application provides 53 RESTful API endpoints covering:
| Module | Number of Endpoints | Key Operations |
|---|---|---|
| Connections | 3 | View, Create, Delete |
| Tables | 10 | CRUD, Analysis, Relationships |
| Columns | 3 | View, Add, Modify, Drop |
| Rows | 4 | View, Insert, Update, Delete |
| Queries | 4 | Execute, History, Explain |
| Bulk Operations | 3 | Bulk Insert, Update, Delete |
| Import/Export | 3 | Export Table, Export SQL, Import Data |
| Indexes & Constraints | 6 | Management Operations |
| Saved Queries | 5 | CRUD Operations |
| Backups & Performance | 8 | Monitoring and Management |
| Validation | 3 | Rule Management and Execution |
- CORS enabled for development flexibility.
- SQL injection prevention via parameterized queries.
- In-memory credential storage (no persistence).
- Connection isolation per user session.
- User authentication system.
- Role-based access control (RBAC).
- Encrypted secret storage.
- Audit log for all operations.
- Session management and API rate limiting.
| Metric | Details |
|---|---|
| Query Execution | <10ms for simple queries, <1s for complex operations. |
| Backup Speed | ~1MB/s for SQL dump, ~2MB/s for JSON export. |
| Data Grid | Pagination handles tables with millions of rows. |
| Concurrent Connections | Supports multiple simultaneous database connections. |
| Memory Usage | Minimal with streaming for large exports. |
| API Response Time | <100ms for most operations. |
Contributions are welcome! Please see the Developer Guide for details on:
- Setting up the development environment.
- Code style and conventions.
- Submitting pull requests.
- Reporting issues.
All Rights Reserved to Alqudimi Technology ยฉ 2024
Abdulaziz Alqudimi
- ๐ง Email:
eng7mi@gmail.com,alqudimitechnology@gmail.com 
GitHub: @Alqudimi
https://github.com/Alqudimi/OmniCoreDB
This project leverages modern web technologies and best practices to provide a robust database management solution. Special thanks to the open-source community for the amazing tools and libraries that made this project possible.