Features

Table Browser

Overview

The main interface displays all database tables in a searchable, sortable list.

Features

Table Information Display

• Table Name: Full table name with WordPress prefix identification
• Row Count: Total number of rows (formatted with thousands separator)
• Table Size: Size in megabytes (MB), rounded to 2 decimal places
• Table Type Indicator: Visual distinction between WordPress and custom tables

Search Functionality

• Real-time Search: Filter tables as you type
• Case-insensitive: Matches regardless of case
• Name Matching: Searches within table names

Sorting Options

Sort tables by:

• Name: Alphabetical order (A-Z or Z-A)
• Row Count: Number of rows (ascending/descending)
• Size: Table size in MB (ascending/descending)
• Type: WordPress tables first, then custom tables

Filtering

• Show Non-WordPress Tables Only: Toggle to show only custom/plugin tables
• WordPress Table Detection: Automatically identifies WordPress core tables
• Prefix-Agnostic: Works with any custom table prefix

User Interface

• Left Sidebar: Table list with search and filters
• Right Panel: Table details or empty state
• Responsive Design: Drawer navigation on mobile devices
• Dark Mode: Full dark mode support

Table Structure View

Overview

Detailed view of table structure including columns, indexes, and relationships.

Column Information

For each column, displays:

• Field Name: Column name
• Type: Data type (e.g., VARCHAR, INT, TEXT)
• Null: Whether NULL values are allowed (YES/NO)
• Key: Primary key, unique key, or index indicator
• Default: Default value (if any)

Index Information

Displays all indexes with:

• Index Name: Name of the index
• Column: Column(s) included in index
• Type: Index type (BTREE, HASH, etc.)

Foreign Key Relationships

Shows foreign key constraints:

• Constraint Name: Name of the foreign key constraint
• Column: Local column name
• Referenced Table: Related table name
• Referenced Column: Related column name

Features

• Clean Table Format: Easy-to-read table display
• Formatted Types: Uppercase type names for clarity
• Key Indicators: Visual badges for primary/unique keys
• NULL Handling: Clear indication of nullable columns

Table Data View

Overview

Browse and explore table data with powerful search, sort, and pagination features.

Pagination

• Configurable Per-Page: Default 50 rows, adjustable
• Page Navigation: Previous/Next buttons
• Page Indicator: Current page and total pages
• Row Count Display: Shows range of displayed rows
• Total Count: Total number of rows in table

Search Functionality

• Multi-Column Search: Searches across all columns simultaneously
• LIKE Matching: Uses SQL LIKE for pattern matching
• Debounced Input: 500ms delay to reduce API calls
• Real-time Results: Updates as you type

Sorting

• Column Header Click: Click any column header to sort
• Toggle Direction: Click again to reverse sort order
• Visual Indicator: Arrow icon shows sort direction
• Column Validation: Only sorts by valid column names

Data Display

• All Columns: Displays all columns in table
• NULL Values: Shows "NULL" in italic gray text
• Object/Array Values: JSON stringified for display
• Truncated Display: Long values truncated with tooltip
• Responsive Table: Horizontal scroll on small screens

Features

• Loading States: Skeleton loaders during data fetch
• Empty States: Helpful message when no data found
• Error Handling: User-friendly error messages
• XSS Protection: All values properly escaped

SQL Query Editor

Overview

Execute read-only SELECT queries safely with syntax validation and result display.

Query Input

• Large Textarea: Comfortable editing space
• Syntax Highlighting: Visual query structure
• Keyboard Shortcuts: Ctrl+Enter (Cmd+Enter on Mac) to execute
• Placeholder Text: Helpful example query

Query Execution

• SELECT Only: Only SELECT queries allowed
• Syntax Validation: Prevents dangerous operations
• Comment Removal: Strips SQL comments automatically
• Whitespace Normalization: Cleans up query formatting
• Keyword Blacklist: Blocks DROP, DELETE, UPDATE, INSERT, etc.
• Multiple Statement Prevention: Blocks semicolon-separated queries

Result Display

• Formatted Table: Clean table view of results
• Column Headers: Auto-detected from query results
• Row Count: Shows number of rows returned
• Scrollable: Horizontal and vertical scrolling
• NULL Handling: Clear NULL value indication

Query History

• Last 20 Queries: Stored locally in browser
• Query Details: Shows query text, timestamp, and row count
• Quick Reload: Click to reload previous query
• History Sidebar: Slide-out panel for history access

Safety Features

• Automatic LIMIT: Adds LIMIT if not present (max 10,000 rows)
• LIMIT Validation: Enforces maximum result limit
• Error Messages: Generic errors to prevent information disclosure
• Query Timeout: Prevents long-running queries

Table Deletion

Overview

Safely remove orphaned plugin tables with comprehensive security measures.

Deletion Process

Step 1: Password Verification

• Password Modal: Requires user password entry
• Autofill Prevention: Multiple techniques to prevent browser autofill
• Password Validation: Verifies against WordPress user account
• Error Handling: Clear error messages for invalid passwords

Step 2: Confirmation Dialog

• Table Name Display: Shows table name in confirmation
• Warning Message: Clear indication that action cannot be undone
• Confirm Button: Explicit "Yes, delete table" button
• Cancel Option: Easy cancellation

Step 3: Deletion Execution

• Safety Checks: Validates table is safe to delete
• WordPress Core Protection: Cannot delete WordPress tables
• System Table Protection: Blocks system table deletion
• Audit Logging: Logs deletion with user and timestamp

Safety Features

• Non-WordPress Tables Only: Only custom tables can be deleted
• Prefix-Agnostic Detection: Works with any WordPress prefix
• Multisite Awareness: Recognizes multisite table patterns
• Double Confirmation: Password + confirmation dialog
• Permanent Deletion: Cannot be undone (no soft delete)

Visual Indicators

• Delete Button: Red-styled button for destructive action
• Only on Custom Tables: Button only appears for non-WordPress tables
• Loading States: Visual feedback during deletion
• Success Notification: Confirmation message after deletion

Advanced Filtering

Table Type Filter

• Toggle Checkbox: "Show non-WordPress tables only"
• Real-time Filtering: Updates list immediately
• Preserves Search: Works with search functionality
• Preserves Sort: Maintains sort order

WordPress Table Detection

The system uses sophisticated detection:

1. Standard Table List: Maintains list of WordPress core tables
2. Prefix Detection: Uses $wpdb->prefix to identify prefix
3. Name Matching: Compares table name (without prefix) to standard list
4. Multisite Support: Recognizes numbered tables (e.g., wp_2_posts)

Standard WordPress Tables

Core Tables (12):

• commentmeta, comments, links, options
• postmeta, posts, terms, termmeta
• term_relationships, term_taxonomy
• usermeta, users

Multisite Tables (6, if enabled):

• blogs, blog_versions, registration_log
• signups, site, sitemeta

Custom Prefix Support

• Any Prefix: Works with wp_, myprefix_, xyz_, etc.
• Dynamic Detection: Detects prefix at runtime
• No Hardcoding: No assumptions about prefix value

User Interface Features

Dark Mode

• Full Support: All components support dark mode
• Automatic Detection: Respects system preferences
• Consistent Styling: Zinc color palette throughout
• High Contrast: Accessible color combinations

Responsive Design

• Mobile Drawer: Slide-out panel on mobile devices
• Touch-Friendly: Large tap targets
• Adaptive Layout: Adjusts to screen size
• Horizontal Scroll: Tables scroll horizontally on small screens

Loading States

• Skeleton Loaders: Placeholder content during loading
• Spinner Animations: Visual feedback for operations
• Progress Indicators: Shows operation progress
• Disabled States: Prevents interaction during loading

Error Handling

• User-Friendly Messages: Clear, actionable error messages
• Error Notifications: Toast-style notifications
• Retry Options: Ability to retry failed operations
• Graceful Degradation: Continues working despite errors

Empty States

• Helpful Messages: Guidance when no data available
• Visual Icons: Icon indicators for empty states
• Action Suggestions: Suggests next steps
• Consistent Design: Matches overall UI style

Keyboard Shortcuts

• Ctrl+Enter / Cmd+Enter: Execute SQL query (in query editor)
• Escape: Close modals and dialogs
• Enter: Submit password (in password modal)

Performance Features

• Pagination: Limits data transfer
• Lazy Loading: Loads structure on demand
• Debounced Search: Reduces API calls
• Efficient Queries: Optimized database queries
• Result Limits: Maximum 10,000 rows per query

Accessibility Features

• Semantic HTML: Proper HTML structure
• ARIA Labels: Screen reader support
• Keyboard Navigation: Full keyboard support
• Focus Management: Proper focus handling
• Color Contrast: WCAG compliant colors