Updated
Database · for FastAPI

Database for FastAPI: what 13 makers' products chose

Among 13 makers' products built with FastAPI that we know the database of, PostgreSQL leads: 6 of them (46%). Next come Supabase (3) and MongoDB (3).

Where the data lives: a whole backend platform (database, auth and storage in one project), a managed database you reach from your own code, or the raw engine on your own server. Postgres is the default unless you have a reason to pick otherwise; analytics and graph databases sit next to it for workloads it handles poorly, not instead of it. How your code talks to it is its own decision (Database Access & ORMs).

What makers on FastAPI chose

OptionFastAPI productsAll makersFree forAt 10,000 users
PostgreSQLRun it yourself6 (46%)8%——
SupabaseBackend platform3 (23%)45%~500 users$25/moPro
MongoDBManaged database3 (23%)10%~500 users$58/moAtlas Dedicated M10
FirebaseBackend platform1 (8%)15%~2,000 users$9.66/moBlaze (pay as you go)
NeonManaged database1 (8%)8%None$22/moLaunch
MySQLRun it yourself1 (8%)1%——
TinybirdAnalytics (OLAP)1 (8%)2%~13,000 users—

Live makers' products with a source for both: that they're built with FastAPI, and what they use for database. A product using two options counts in both; not market share. "All makers" is the option's share among every maker's product that made this decision.

Costs are the cheapest plan that fits, from each vendor's pricing page, at the usage our stack planner assumes for a product with that many users. Free for: the users its cheapest plan a business can use stays free for; plans for personal use only, like a non-commercial hobby tier, don't count.

Which to pick, by situation

  • You want the database, auth and file storage in one project, and plain SQL you can take elsewhereSupabase 3 here
  • Your traffic is bursty or you run many preview deploys, and idle hours shouldn't cost muchNeon 1 here
  • You already run your own server and want a flat monthly costPostgreSQL 6 here

PostgreSQL

Run it yourself

6 FastAPI products here (46%).

In Replit

Best forThe engine behind most of the hosted options above, run on your own server or container for full control and a flat cost.

Trade-offBackups, upgrades, failover and connection pooling are yours to set up and watch.

“PostgreSQL gives us the best balance between well-structured data persistency and clean code principles”

Makers like
  • It is rock-solid, keeps data consistent with strong transactions, and handles complex relational queries well. 4 sources
  • With pgvector, embeddings live next to relational data, so AI features need no separate vector database. 4 sources
Makers watch out for
  • Built-in full-text search lacks corpus-wide relevance ranking like BM25 and can need very large indexes. 2 sources
  • It has no loose index scan, so SELECT DISTINCT over large tables needs manual workarounds. 2 sources
FastAPI products on PostgreSQL
Warestack
WarestackEngineering delivery governance for GitHub organizations

“PGVector's native vector operations with PostgreSQL's ACID compliance works perfectly. We're storing millions of embeddings with sub-millisecond similarity search using cosine distance. The async connection pooling handles concurrent connections, while the vector indexing makes our query super fast. Having vector search, full-text search, and relational data in one database eliminates the complexity of managing multiple data stores.”

DatabaseMaker says so · source ↗
Permit.io
Permit.ioPermissions for The AI Era

“PostgreSQL gives us the best balance between well-structured data persistency and clean code principles”

DatabaseMaker says so · source ↗

All of PostgreSQL: who uses it, alternatives →

Supabase

Backend platform

3 FastAPI products here (23%). Free up to about 500 users. About $25 a month at 10,000 users (Pro).

llms.txtMCPCLIIn Bolt, Lovable, Rork, v0

Best forPostgres plus auth, storage and realtime in one project.

Trade-offAuth, storage and database in one vendor makes leaving harder later, and free projects pause after a week without activity.

“Supabase provides us with a powerful, real-time backend, enhancing our data handling capabilities and making our product more robust and responsive.”

Makers like
  • One project covers Postgres, auth, storage and realtime, so a solo founder ships without stitching vendors or hiring a backend team. 4 sources
  • It is real Postgres with SQL, row-level security and pgvector rather than a proprietary store. 4 sources
Makers watch out for
  • Row-level security policies are hard to get right, so many apps end up exposing data publicly. 4 sources
  • Reliability has been shaky for some, and it is not really built for self-hosting in practice. 1 source

Status page: 25+ incidents in the last 90 days, 6 major (its own page, 2026-10-19).

FastAPI products on Supabase
SplitHub.io
SplitHub.ioThe Ultimate Tool for Split Testing

“Supabase provides us with a powerful, real-time backend, enhancing our data handling capabilities and making our product more robust and responsive.”

DatabaseMaker says so · source ↗

All of Supabase: who uses it, alternatives, pricing →

MongoDB

Managed database

3 FastAPI products here (23%). Free up to about 500 users. About $58 a month at 10,000 users (Atlas Dedicated M10).

llms.txt

Best forDocument-shaped data and teams already fluent in Mongo.

Trade-offNo joins or schema by default, so relational data and migrations take discipline you'd get for free in Postgres.

“I chose MongoDB for its flexibility and scalability. It's superior to alternatives due to its ability to handle large volumes of unstructured data with ease.”

Makers like
  • The flexible document model lets fast-changing products evolve their data without rigid migrations. 4 sources
  • Atlas starts on a free tier and handles scaling, backups and monitoring, so there is little database to manage. 4 sources
Makers watch out for
  • Its history of unsafe defaults and lost writes left a lasting reputation that still keeps many developers away. 4 sources
  • Anything beyond simple reads and writes is hard, and aggregation pipelines feel primitive next to SQL, which costs more over time. 2 sources

Status page: 13 incidents in the last 90 days, 5 major (its own page, 2026-10-19).

FastAPI products on MongoDB
Rinkoe
RinkoeA Place for Everything

“I chose MongoDB for its flexibility and scalability. It's superior to alternatives due to its ability to handle large volumes of unstructured data with ease.”

DatabaseMaker says so · source ↗

All of MongoDB: who uses it, alternatives, pricing →

Also chosen, and not seen yet

Fewer FastAPI products here: Firebase (1), Neon (1), MySQL (1), Tinybird (1).

Real options for database not seen among these FastAPI products yet: Convex, PlanetScale, Turso.

Who switches, and to what

Public GitHub pull requests whose title says "X to Y", by developers in general, not only on FastAPI.

Getting database right

Pick a managed Postgres unless you have a reason not to. Turn on backups before your first real user, and use the provider's connection pooler from serverless functions.

  • Never restoring a backup until the day you need one — the first bad migration or stray DELETE is a bad time to learn the backup is missing or too old.
  • Opening a fresh database connection in every serverless function call, which runs Postgres out of connections under modest traffic; use the provider's connection pooler.
  • Changing the schema by hand in the production console instead of through migrations, so local, preview and production databases quietly drift apart.

The rest of the FastAPI stack

What makers' FastAPI products chose for their other decisions, the most common pick for each:

Questions

What do most FastAPI apps use for database?

Among 13 makers' products built with FastAPI that we know the database of, PostgreSQL leads: 6 of them (46%). Next come Supabase (3) and MongoDB (3).

What does database cost for a FastAPI app with 10,000 users?

On our usage model at 10,000 users, Supabase comes to about $25 a month (Pro); MongoDB comes to about $58 a month (Atlas Dedicated M10); Firebase comes to about $9.66 a month (Blaze (pay as you go)); Neon comes to about $22 a month (Launch). Prices are from each vendor's pricing page.

Which database option stays free longest for a FastAPI app?

Tinybird: on our usage model its cheapest plan stays free up to about 13,000 users.

How this is counted: a product is on FastAPI when a live-product source says so (the maker, its website, a customer story or a subprocessor list), and the same for its database. How evidence is collected.