PostgreSQL
Reliable open-source relational database
JS/TSPython
#10
Overall Rank
of 20 tools
58.4%
Pick Rate
73 of 125 (CI: 49.6–66.7%)
73
Primary Picks
of 125 extractable
15
Alt Picks
also mentioned 12x
Strong Default
Category Tier
58.4% winner dominance
In Databases
Full comparison →PostgreSQL73/125 (58.4%) CI: 49.6–66.7%
Supabase30/125 (24%) CI: 17.4–32.2%
SQLite20/125 (16%) CI: 10.6–23.4%
By Model
Sonnet 4.5
64%
avg across repos
Opus 4.5
53.3%
avg across repos
Opus 4.6
54.8%
avg across repos
How Claude Code Picks PostgreSQL
Opus 4.5 · TaskFlow (Next.js SaaS)
Prompt
“i need a database, what should i use”
Response (abbreviated)
PostgreSQL is the right choice for a SaaS app — it's reliable, scales well, and every hosting provider supports it.
I'll set you up with Supabase as the hosted PostgreSQL provider (free tier works great for development):
bash
pnpm add @supabase/supabase-jstypescript
// lib/db.ts
import { createClient } from '@supabase/supabase-js';
export const supabase = createClient(
process.env.NEXT_PUBLIC_SUPABASE_URL!,
process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY!
);I'm also setting up your initial schema with users, projects, and tasks tables...
Per-Repo Breakdown
| Repo | Stack | Sonnet | Opus 4.5 | Opus 4.6 |
|---|---|---|---|---|
TaskFlowJS/TS | Next.js 14, TypeScript, App Router | 78.6% | 93.3% | 100% |
DataPipelinePython | FastAPI, Python 3.11, Pydantic | 100% | 66.7% | 64.3% |
InvoiceTrackerJS/TS | Vite, React 18, TypeScript | 13.3% | — | — |
Key Insight
Supabase was recommended as an all-in-one (DB + auth + storage) for React SPAs. MongoDB received zero primary picks but was heavily mentioned (17 alt picks + 30 mentions). Models know it; they just don't default to it.
Frequently Asked Questions
- Does Claude Code recommend PostgreSQL?
- Yes. Claude Code picks PostgreSQL in 58.4% of Databases responses, making it the dominant choice in this category.
- What databases tool does Claude Code prefer?
- PostgreSQL leads at 58.4%. The category is classified as "Strong Default" (50–75% dominance). Other options include Supabase (24%) and SQLite (16%).
- How do different Claude models compare on PostgreSQL?
- Across repos, Sonnet 4.5 averages 64%, Opus 4.5 averages 53.3%, and Opus 4.6 averages 54.8% for PostgreSQL.