Free open public domain beer database & schema (beer.db) for use in any (programming) language (e.g. uses plain text fixtures/data sets)
Pull request Compare This branch is 209 commits behind openbeer:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.

Welcome to beer.db

A free open public domain beer database & schema for use in any (programming) language (e.g. uses plain text fixtures/data sets)


Build yourself a copy of the beer.db from the plain text fixtures in three steps.

Step 1: Get a copy of the world.db fixtures

$ git clone git://

Step 2: Get a copy of the beer.db fixtures

$ git clone git://

Step 3: Let's build the beer.db

$ beerdb setup --include ./beer.db --worldinclude ./world.db

That's it.

Web Admin Demo

Try the beer.db Web Admin demo running on Heroku

Web Service / HTTP JSON API - GET /beer/guinness

Try the beer.db HTTP JSON API demo running on Heroku

Tables, Schema

The beer.db includes the following tables:

  • beers
  • breweries
  • tags
  • taggings (join table)

Command Line Tool

To build your own beer.db copy use the beerdb command line tool. See the beerdb command line tool project for more.

Plain Text Fixtures

The beerdb command line tool lets you import beer and brewery data in plain text. Example:


alaskan, Alaskan Brewing Co., 1986, AK, city:juneau, Juneau | AK 99801-9540 // 5429 Shaune Dr.
brooklyn, Brooklyn Brewery, 1987, NY, city:newyork, Brooklyn | NY 11249 // #1 Brewers Row // 79 N 11th St.
dixie, Dixie Brewing Co., 1907, LA, city:neworleans, New Orleans | LA 70119 // 2401 Tulane Ave.


Alaskan Pale, 5.2%, by:alaskan, golden_ale
Alaskan Amber, 5.3%, by:alaskan,  alt
Alaskan IPA|Alaskan India Pale Ale, 6.2%, by:alaskan, ipa|india_pale_ale
Alaskan Smoked Porter, 6.5%, by:alaskan,  porter

Brooklyn Lager,     5.2%, by:brooklyn, lager|american_amber_lager
Brooklyn Brown Ale, 5.6%, by:brooklyn,  brown_ale|american_brown_ale
Brooklyn East India Pale Ale,  6.9%, by:brooklyn,  ipa|india_pale_ale
Brooklyn Pilsner,  5.1%, by:brooklyn,  pilsner|golden_lager
Brooklyn Black Chocolate Stout,  10.0%, by:brooklyn, imperial_stout
Brooklyn Dry Irish Stout, 4.7%, by:brooklyn, dry_irish_stout
Brooklyn Oktoberfest, 5.5%,    by:brooklyn, maerzen|oktoberfest

Dixie|Dixie Lager, 4.6%, by:dixie, american_lager
Dixie Blackened Voodoo|Dixie Blackened Voodoo Lager,  5.0%, by:dixie,  munich_dunkel|dark_lager

Real World Usage

  • beer.db.admin - beer.db Web Admin Tool in Ruby on Rails (version 3.2 and up).



The beer.db schema, data and scripts are dedicated to the public domain. Use it as you please with no restrictions whatsoever.