pgref PRO
The complete SQL toolkit for developers who want answers faster than Stack Overflow. Powered by Claude, built for PostgreSQL.
Secure checkout via Stripe · Instant access after payment
AI Query Assistant
Describe what you need in plain English. Get 3 SQL variants: readable, optimised, and educational — each with copy and "load in Playground" buttons.
PRO onlyError Code Explainer
Paste any PostgreSQL error message. AI returns the exact cause in your context, 3 ranked fixes, and a safe diagnostic query.
PRO onlyPerformance Analyzer
Paste a slow query. Get severity-tagged issues (SELECT *, missing indexes, correlated subqueries) plus rewritten SQL.
PRO onlyMy Queries Library
Save, tag, and search your queries. Export as a .sql file. Import from any .sql file. One-click to open in Playground.
PRO onlySQL Cookbook
50+ real-world patterns: reporting, data quality, performance, JSON, window functions, CTEs. AI adapts each recipe to your schema.
PRO onlySchema Designer Pro
Describe a table in plain English → AI suggests columns, types, and constraints. Plus index advisor based on your query patterns.
PRO onlyAI Code Review
Paste SQL (query, migration, stored procedure). Get a structured audit: correctness, security risks, performance gaps, maintainability.
PRO onlyMigration Safety Planner
Paste any ALTER TABLE or migration SQL. Get a risk score, exact lock types acquired, zero-downtime alternatives, rollback script, and a production deployment checklist.
PRO onlyEXPLAIN Plan Tutor
Paste a PostgreSQL EXPLAIN (ANALYZE, BUFFERS) output. Every node explained in plain English, bottlenecks highlighted, rewritten query suggested, and relevant index DDL generated.
PRO onlySecurity Audit
Audit SQL for injection vectors, overprivileged roles, missing RLS, sensitive column exposure, SECURITY DEFINER risks, and search_path injection — with CWE/OWASP mapping.
PRO onlySQL Interview Coach
Practise with AI-generated PostgreSQL interview questions across 12 topics and 4 difficulty levels. Get scored, graded, and coached on your answers in real time.
PRO onlyData Model Designer
Describe your application in plain English and receive a complete production schema: DDL with all constraints, indexes, RLS, triggers, ER diagram, normalization analysis, and common queries.
PRO onlyIndex Advisor
Paste your schema and slow queries for exhaustive index recommendations — btree, GIN, GiST, BRIN, partial, covering, and expression indexes — plus unused index detection and a maintenance plan.
PRO onlyFAQ
How does activation work?
After purchase, you receive an email with a one-click activation link. Click it and your browser saves a secure token — no account or password required.
Is my API key safe?
Yes. The Claude API key lives on our server only. Your browser never sees it. All AI calls go through our API endpoint, which validates your PRO token before calling Claude.
Can I use it offline?
The free tools (Playground, Schema Builder, etc.) work offline. The AI features require an internet connection to reach the Claude API.
What if I need help?
Email dxk.developer@gmail.com — responses within 48 hours.
Already have an account? · Activate with token