Skip to main content

Usage Examples

Connection Management​

"Show me all my database connections"
"Test the connection to my PostgreSQL database"
"Tell me about my connection named 'prod-db'"

Running Queries​

SELECT (safe)​

"Run on my sales database: SELECT COUNT(*) FROM orders WHERE date > '2024-01-01'"

"Execute on warehouse:
SELECT
    DATE_TRUNC('month', order_date) as month,
    SUM(total_amount) as revenue
FROM orders
WHERE order_date >= '2024-01-01'
GROUP BY 1"

INSERT/UPDATE/DELETE​

"Insert into customers:
INSERT INTO customers (name, email) VALUES ('John Doe', 'john@example.com')"

"Update email for customer 123:
UPDATE customers SET email = 'new@example.com' WHERE customer_id = 123"

"Delete test records:
DELETE FROM test_orders WHERE created_date < '2024-01-01'"

Schema Operations​

Create tables​

"Create a products table:
CREATE TABLE products (
    id SERIAL PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    price DECIMAL(10,2),
    created_at TIMESTAMP DEFAULT NOW()
)"

Modify tables​

"Add a description column:
ALTER TABLE products ADD COLUMN description TEXT"

Drop tables​

"Drop the test_products table - confirm this action"

Schema Inspection​

"What's the schema of the users table?"
"List all tables in my database"
"Show me columns in the orders table"

Data Export​

"Export customer data to CSV:
SELECT customer_id, name, email FROM customers"

"Export products as JSON:
SELECT id, name, price FROM products WHERE active = true"

Storing Notes​

"Save this insight: Q4 showed 23% increase in mobile orders. Tag as 'quarterly'"
"Show me all insights tagged 'quarterly'"

Safety Features​

Dangerous operations are blocked or require confirmation:

"DROP DATABASE production"  -- blocked
"DELETE FROM users"         -- warns about missing WHERE
"Drop the test_table"       -- requires confirmation