Notes and history

​

Query history

​

What’s stored

• Query text: The complete SQL statement
• Timestamp: When the query was executed
• Server and database: Where it ran
• Execution time: Duration in milliseconds
• Row count: Number of rows affected or returned
• Status: Success or error
• Error details: If the query failed

​

Viewing history

• Most recent queries first
• Color-coded status (green for success, red for errors)
• Expandable query text for long queries
• Hover to see full details

​

Using history

1. Load it into the current editor
2. Modify as needed
3. Re-execute

​

History limits

• Last 100 queries per server/database combination
• Older queries are automatically removed
• Total history size limited to 5MB

​

Clearing history

1. Open Settings → Data Management
2. Click Clear Query History
3. Confirm the action

​

Saved queries

​

Saving a query

1. Write or load your query in the editor
2. Click Save Query (bookmark icon)
3. Fill in:
   • Name: Descriptive name for the query
   • Description (optional): What the query does
   • Tags (optional): Keywords for organization
4. Click Save

​

Loading saved queries

1. Click Load Query button
2. Browse or search your saved queries
3. Click a query to load it

• Server: Which PostgreSQL server
• Database: Which database
• Tags: Custom categories

​

Editing saved queries

1. Load the query in the editor
2. Make your changes
3. Click Save Query again
4. Use the same name to overwrite, or a new name to create a copy

​

Deleting saved queries

1. Open the Load Query dialog
2. Hover over the query card
3. Click the Delete button (trash icon)
4. Confirm deletion

​

Query templates

​

Available templates

​

Table inspection

-- View first 10 rows
SELECT * FROM table_name LIMIT 10;

-- Table structure
SELECT 
  column_name, 
  data_type, 
  character_maximum_length, 
  is_nullable
FROM information_schema.columns
WHERE table_name = 'table_name';

​

Performance analysis

-- Active connections
SELECT 
  pid, 
  usename, 
  application_name, 
  state, 
  query
FROM pg_stat_activity
WHERE state != 'idle';

-- Table sizes
SELECT 
  schemaname, 
  tablename, 
  pg_size_pretty(pg_total_relation_size(schemaname||'.'||tablename)) AS size
FROM pg_tables
ORDER BY pg_total_relation_size(schemaname||'.'||tablename) DESC
LIMIT 20;

​

Index analysis

-- All indexes on a table
SELECT 
  indexname, 
  indexdef
FROM pg_indexes
WHERE tablename = 'table_name';

-- Unused indexes
SELECT 
  schemaname, 
  tablename, 
  indexname, 
  idx_scan
FROM pg_stat_user_indexes
WHERE idx_scan = 0
ORDER BY schemaname, tablename;

​

Using templates

1. Click Templates in the toolbar
2. Browse template categories
3. Click a template to load it
4. Customize placeholders (like table_name)
5. Execute the query

​

Notes and scratch pad

• Quick notes and reminders
• Documentation of database structure
• Query planning and brainstorming
• Paste temporary data

​

Creating notes

1. Click Notes in the sidebar
2. Click New Note
3. Give your note a title
4. Write content using Markdown
5. Notes auto-save as you type

​

Organizing notes

• Folders: Organize notes by project or topic
• Tags: Add keywords for easy searching
• Favorites: Star important notes
• Search: Full-text search across all notes

​

Markdown support

# Database Schema Notes

## Users Table
- Primary key: `id` (SERIAL)
- Unique: `email`
- Indexes: `email`, `created_at`

## TODO
- [ ] Add index on user_id in orders table
- [ ] Create view for active users
- [x] Update password hashing

​

Sharing notes

1. Open the note
2. Click Export → Markdown
3. Share the .md file

​

Storage and backup

• Location: Browser localStorage
• Encryption: Included in encrypted backups (.enc files)
• Size: Limited by browser (typically 5-10 MB)
• Persistence: Survives browser restarts

​

Creating backups

1. Go to Settings → Backup & Restore
2. Click Create Backup
3. Choose:
   • Full backup: Everything including connection details (encrypted)
   • Data only: History, queries, notes (encrypted)
   • Settings only: No sensitive data (plain JSON)
4. Save the backup file

​

Restoring from backup

1. Go to Settings → Backup & Restore
2. Click Restore from Backup
3. Select your .enc backup file
4. Enter the encryption password
5. Choose what to restore:
   • Connection servers
   • Saved queries
   • Query history
   • Notes
   • Settings
6. Click Restore

​

Next steps