What is Connection pooler?

A middleman that lets many requests share a few database connections, because databases accept only a limited number.

Where Connection pooler goes wrong in real apps

Each of these is a short scenario built from a real failure in an app made with AI. Read the answer here, or walk through it yourself in about four minutes.

  • Launch day · 4 minutes · Pro

    Every page spins forever

    Your post goes viral. Within minutes every page spins, then fails. Your database dashboard says CPU is nearly idle.

    Why does my app hang with too many connections?

    Each copy of a serverless function opens its own database connections, and a traffic spike runs many copies at once, so the database hits its connection limit and refuses new ones. Connect through your database's connection pooler, which shares a few connections across many requests.

    Read the fix

  • Data you can lose · 5 minutes · Free

    The agent that reset production

    You asked your coding agent to fix a failing migration. It says it 'reset the database to resolve drift'. Your live customers are gone.

    How do I stop an AI agent deleting my database?

    Do not keep production database credentials where the agent runs. Use a separate development database locally, give production a role that cannot drop tables, and keep backups the agent cannot reach. Instructions like 'never touch production' are not enough; only permissions reliably stop a destructive command.

    Walk it, free

Related terms

Database
Where your app keeps its data, organised in tables, like a set of spreadsheets.
Request
A message your browser (or any program) sends to a server asking for something: 'give me invoice 105' or 'save this profile'.
Table, row, column
A table is like one spreadsheet (orders). Each row is one item (one order); each column is one detail (price, date).
Secret key
A password your app uses to talk to a paid service. Anyone who sees it can use it, and spend your money.
Environment variable
A setting stored outside your code, like a secret key. Your laptop and your live site each have their own copy.
Production
The real, live version of your app that customers use, as opposed to the copy on your laptop.

All 62 terms in the glossary