User Documentation
Learn how to effectively use Database Manager features to manage your databases, create backups, and generate migrations.
Database Manager provides a comprehensive interface for managing your databases directly from the client portal. Access all features from your dashboard without needing external database tools.
Quick Access Points:
- • SQL Query Interface: Execute custom SQL queries with syntax highlighting
- • Database Designer: Visual ER diagram editor for schema design
- • Export/Import: Move data between environments easily
- • Backup Manager: Create and restore database backups
💡 Pro Tip: Navigate to your Dashboard and click on "Database Manager" to access all features in one place.
The SQL Query Interface allows you to execute custom SQL queries directly against your database with real-time results and syntax highlighting.
📝 Write Queries
Use the code editor with syntax highlighting to write SELECT, INSERT, UPDATE, or DELETE queries.
📊 View Results
Results are displayed in a formatted table with options to export to CSV or JSON.
Example Query:
SELECT * FROM users WHERE status = 'active' LIMIT 100;
⚠️ Important: Always test queries on a development environment first. Use LIMIT clauses to avoid retrieving large datasets.
The Visual Database Designer provides an interactive canvas to design, visualize, and understand your database schema with drag-and-drop functionality.
Designer Features:
Rearrange tables visually
See foreign key connections
Add new tables visually
Save as SQL or Prisma
💡 How to Access: Click on "Database Designer" from your dashboard to open the visual editor. Your layout positions are automatically saved.
Automatically generate migration files and schema definitions from your existing database structure. Perfect for synchronizing databases across different environments.
🔷 Prisma Schema Generator
- • Generate complete Prisma schema
- • Includes all relationships
- • Preserves indexes and constraints
- • Ready for Next.js projects
🔶 Laravel Migration Generator
- • Create Laravel migration files
- • Auto-detect column types
- • Foreign keys included
- • Download as ZIP archive
How to Generate:
- Navigate to "Migration Generator" or "Prisma Generator" from your dashboard
- Select the tables you want to include (or select all)
- Click "Generate" button
- Download the generated files as a ZIP archive
- Extract and use in your project
✅ Use Case: Perfect for migrating from development to production, or syncing database schemas across team members.
Create secure backups of your database and restore them when needed. Keep your data safe with automated and manual backup options.
💾 Create Backup
- Go to "Database Backups"
- Click "Create New Backup"
- Enter a backup name
- Select backup options
- Click "Create Backup"
♻️ Restore Backup
- Browse your backups list
- Select the backup to restore
- Click "Restore" button
- Confirm the restoration
- Wait for completion
Backup Features:
⚠️ Important: Always test your backups by restoring them in a test environment. Regular backups are essential for data security.
Transfer data between databases or environments using multiple export formats including SQL, CSV, and JSON.
📤 Export Formats:
- • SQL (MySQL/MariaDB)
- • CSV for spreadsheets
- • JSON structured data
- • Prisma schema files
📥 Import Options:
- • Upload SQL dump files
- • Import from CSV files
- • Restore from backups
- • Bulk data import
💡 Quick Tip: Use Export/Import to move data between staging and production environments, or share sample data with your team.
Need More Help?
If you have questions or need assistance with any Database Manager features, our support team is here to help you.
Back to Dashboard