Database Workflow

Database Explorer

# Select a saved miudb connection
<leader>Dd

# List saved miudb connections
<leader>Dl

# Run current SQL buffer
<leader>Dq

Query Development

nvim query.sql

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

# Execute query
<leader>j  # Execute current SQL buffer

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
<leader>j

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