Database Workflow¶

Database Explorer¶

# Open database explorer
<leader>Dd

# Connect to database
# Press Enter or 'o' to connect
# Press 'x' to toggle connection

# Disconnect all
<leader>Dx

Query Development¶

nvim query.sql

# Use AI for SQL generation
<leader>ac  # "Find users who haven't logged in for 30 days"

# Execute query
BB  # Execute selection or entire file

Example Query¶

SELECT u.id, u.email, u.last_login
FROM users u
WHERE u.last_login < NOW() - INTERVAL '30 days'
   OR u.last_login IS NULL;

Schema Design¶

<leader>ac  # AI chat
"Design a database schema for an e-commerce platform"

# AI provides:
# - Table structure
# - Relationship mappings
# - Index suggestions
# - Normalization advice

Create Migrations¶

nvim migrations/001_create_users.sql

# Execute migration
BB

Query Optimization¶

1. Identify Slow Queries¶

# Use database monitoring tools
# Profile query performance

2. Optimize with AI¶

# Select slow query
<leader>ao  # AI optimization suggestions

3. Test Optimizations¶

# Compare execution plans
# Measure performance improvements

4. Document¶

# Add comments to optimized queries
# Update documentation