TheCocktailDB API

Build a cocktail recommendation engine from your home bar

Pull cocktail recipes, ingredients, and images. Build a 'what can I make?' tool that matches recipes to your available ingredients.

Free test key. Full access via Patreon ($2/mo).

TheCocktailDBdocs →

How it works with Loony

Describe it.
Deploy it.
Query it.

Managed database.

Your TheCocktailDB data lives in its own Postgres instance. Zero config. Data accumulates over time.

Scheduled syncs.

Cron jobs run on Loony infra. Every minute on free. Your data stays fresh without you thinking about it.

REST + MCP endpoints.

Query from your agent, your dashboard, or connect BI tools directly. Full OpenAPI spec included.

TerminalSchema

$ "Pull all cocktail recipes from CocktailDB. Store my home bar inventory. Build a recommendation view that matches available ingredients to recipes."

✓ Schema validated
✓ Database provisioned
✓ Scripts deployed
✓ Schedules registered

Done.

# Your data is now at:
REST  /data/v1/cocktaildb/query
MCP   /mcp/v1/cocktaildb/mcp
SQL   psql $DATABASE_URL

What you get

CocktailDB has 600+ recipes. Loony stores them alongside your home bar inventory, so the query 'What can I make with what I have, that I haven't tried?' is a SQL join away.

mv_makeable_cocktails
  cocktail      text        -- drink name
  category      text        -- Ordinary | Cocktail | Shot
  ingredients   integer     -- total required
  have          integer     -- ingredients I own
  missing       text        -- what I need to buy
  tried         boolean     -- have I made this