Quick Table Access
DevDb Pro's Quick Table Access feature lets you instantly open any database table from anywhere in VS Code, making database navigation lightning-fast.
The Quick Access Command
Press Cmd+K Cmd+G (Mac) or Ctrl+K Ctrl+G (Windows/Linux) to activate quick table access.
How It Works
- Press the keyboard shortcut from anywhere in VS Code
- Type to search for a table name
- Select a table from the filtered list
- Press Enter to open the table immediately
Features
Fuzzy Search
The search is intelligent and forgiving:
- Case-insensitive - Type "users" to find "Users"
- Partial matches - Type "usr" to find "users"
- Multiple words - Type "order items" to find "order_items"
Multi-Database Support
When you have multiple database connections:
- Tables from all databases appear in the list
- Each entry shows the database name it belongs to
- Easily access tables across different connections
Context Awareness
Quick access is aware of your current context:
- Works from any file or view in VS Code
- No need to switch to the DevDb panel first
- Opens the table in the DevDb view automatically
Usage Examples
Example 1: Find a User Table
- Press
Cmd+K Cmd+G(Mac) orCtrl+K Ctrl+G(Windows/Linux) - Type "user"
- See results: "users", "user_profiles", "user_settings"
- Select "users" and press Enter
Example 2: Navigate While Coding
You're editing a Laravel controller and need to check the orders table:
- Stay in your controller file
- Press the quick access shortcut
- Type "orders"
- Press Enter to instantly view the table
Example 3: Multiple Databases
You have a main app database and an analytics database:
- Press the quick access shortcut
- Type "events"
- See "events (main_db)" and "events (analytics_db)"
- Choose the one you need
Alternative Access Methods
Method 1: From Code
Right-click a table or model name in your code:
- Select "DevDb > Open table at cursor"
- Table opens immediately
Method 2: From Sidebar
Navigate the traditional way:
- Open DevDb panel (
Cmd+K Cmd+DorCtrl+K Ctrl+D) - Expand your database
- Click the table name
Method 3: Command Palette
Use the Command Palette:
- Press
Cmd+Shift+P(Mac) orCtrl+Shift+P(Windows/Linux) - Type "DevDb: Go to Table"
- Search for your table
Tips for Efficiency
Learn the Shortcut
Memorize Cmd+K Cmd+G (Mac) or Ctrl+K Ctrl+G (Windows/Linux):
- Most frequently used DevDb feature
- Saves multiple clicks and navigation steps
- Works from anywhere
Use Partial Names
You don't need to type the full table name:
- "ord" finds "orders"
- "usr" finds "users" and "user_settings"
- "prod" finds "products" and "product_categories"
Combine with Context Menu
For model/entity names in code:
- Right-click the name
- Use "Open table at cursor" for one-click access
Multiple Connections
If you work with multiple databases:
- Note the database name shown in results
- Use it to distinguish between similar table names
Keyboard Shortcuts Reference
| Action | Mac | Windows/Linux |
|---|---|---|
| Quick Table Access | Cmd+K Cmd+G | Ctrl+K Ctrl+G |
| Toggle DevDb Panel | Cmd+K Cmd+D | Ctrl+K Ctrl+D |
| Open Table at Cursor | Right-click → DevDb menu | Right-click → DevDb menu |
Next Steps
- Database Client - Learn about the interface
- Laravel Integration - Code Lens features
- Data Export - Export table data