DirectDB

[CENTER]
<b>DirectDB — Multi-Tab SQL Database Manager</b>
[/CENTER]

Overview
The DirectDB extension provides a powerful, multi-tab SQL database management interface.
It combines a visual query builder, raw SQL editor, data browser, schema explorer, import/export utilities, and query history — all in one seamless system.

With DirectDB, you can construct queries visually, execute raw SQL with syntax highlighting, browse data with filters, explore table structures, import/export data across formats, and review full query history.

Core Tabs

• <b>Query Builder</b> — Visual SELECT/UPDATE/DELETE construction with SQL preview.
  
• <b>Raw SQL</b> — Full-featured SQL editor with syntax highlighting and multi-statement execution.
  
• <b>Browse Data</b> — Interactive table viewer with filters, search, sorting, pagination, and inline editing.
  
• <b>Schema</b> — Complete database structure explorer with column types, keys, defaults, and row counts.
  
• <b>Import/Export</b> — Import CSV files and export results in CSV, JSON, SQL, or Excel.
  
• <b>History</b> — Complete query audit log with search, filters, performance statistics, and copy/rerun.
  
• <b>Read-Only mode</b> — Prevent accidental changes.
  

Features

• <b>Query Builder</b>
  [LIST]
  
• Table and column selection with row counts
  
• WHERE clause editor with conditions
  
• ORDER BY and LIMIT options
  
• Real-time SQL preview
  
• One-click query copying
  
• Export query results
  

Raw SQL

• Syntax highlighting powered by Prism.js
  
• Line/character counters
  
• Quick templates for common queries
  
• Multi-statement execution
  
• Execution results display
  

Browse Data

• Search across all columns
  
• Column filtering and sorting
  
• Configurable pagination
  
• Inline cell editing
  
• Row actions: edit/delete
  
• NULL value visual indicators
  

Schema

• Column details (type, nullability, keys, defaults)
  
• Row counts and primary keys
  
• Table statistics
  
• Visual table grid overview
  
• Column management tools
  

Import/Export

• Export in CSV, SQL, JSON, Excel
  
• CSV import with data validation preview
  
• Bulk operations: truncate, optimize, check
  
• Table selection with header options
  

History

• Complete query audit trail
  
• Filter by query type or errors
  
• Execution statistics and performance metrics
  
• Copy or rerun previous queries
  
• User/IP tracking
  

[/LIST]

Security & Safety

• Confirmation dialogs for destructive actions
  
• User authentication tracking
  
• IP address logging
  
• Error handling with user-friendly messages
  
• SQL injection protection through parameterized queries
  

UI/UX Features

• Responsive design for all devices
  
• Dark/light mode (Filament themes)
  
• Primary key, NULL, and boolean indicators
  
• Loading and disabled button states
  
• Toast notifications for feedback
  
• Hover effects and smooth transitions
  
• Accessible color schemes with contrast compliance
  

Advanced Functionality

• Real-time search with debouncing
  
• Efficient pagination for large datasets
  
• Bulk operations for database maintenance
  
• Clipboard integration for query copying
  
• Keyboard shortcuts and quick actions
  
• File downloads for exports
  

Technical Highlights

• Reactive Livewire components
  
• Database-agnostic (all Laravel-supported DBs)
  
• Lazy loading for optimized performance
  
• Filament-based modular CSS
  
• JavaScript event handling for interactivity
  
• Progressive enhancement for stability
  

Productivity Boosters

• Quick templates for SQL patterns
  
• One-click table switching between tabs
  
• Searchable query history
  
• Multi-format export
  
• Inline editing without leaving interface
  
• Schema visualization with indicators