Saved Queries

Save your frequently used queries for quick access.

Saving a Query

1. Write your query in the editor
2. Press Cmd+Shift+S (macOS) or Ctrl+Shift+S (Windows/Linux)
3. Fill in the details:
   • Name - A descriptive name
   • Description - What the query does (optional)
   • Tags - Keywords for organization (optional)
   • Folder - Group related queries (optional)

Accessing Saved Queries

Open the Saved Queries panel in the sidebar to see all your queries.

Loading a Query

• Click a query to load it into a new tab
• Double-click to load and immediately execute

Sorting

Sort queries by:

• Name (alphabetical)
• Usage count (most used first)
• Last used (recent first)
• Created date

Filtering

• Search by name or description
• Filter by tag to see specific categories
• Filter by folder to see grouped queries

Managing Queries

Edit Query

1. Right-click the query
2. Select Edit
3. Modify name, description, tags, or folder
4. Save changes

Delete Query

1. Right-click the query
2. Select Delete
3. Confirm deletion

View Details

Hover over a query to see:

• Full description
• Tags
• Usage count
• Last used date

Organization

Tags

Add tags to categorize queries:

• reports - Reporting queries
• debug - Debugging queries
• cleanup - Data cleanup queries

Folders

Create folders to group related queries:

• Sales/Monthly Reports
• Users/Analytics
• Maintenance

Usage Tracking

data-peek tracks how often you use each query:

• Usage count increments each time you run it
• Last used shows when you last ran it

Use this to identify your most valuable queries.

Tips

• Give queries descriptive names
• Add comments in the SQL for context
• Use tags consistently across queries
• Regularly clean up unused queries