• RAW DATA
  • STATISTICS
  • ANALYSIS
  • HUMAN

How to analyze brewery density with your AI

Connect the Open Brewery DB to your AI client to pull brewery counts and compare market saturation across different regions.

Ask AI about this page

Short answer

How can I compare brewery counts by state or type?

Your AI pulls live data from the Open Brewery DB to count breweries based on your filters. You'll get a breakdown of how many establishments exist in a given state, country, or category. This allows you to spot trends in brewery density immediately.

Where your data lands.

The results of your analysis.

The AI processes your request and organizes the data into these specific outcomes.

RAW DATA

Filtered brewery lists

The AI finds every brewery that matches your state or type criteria. You get a clean list of names and locations.

STATISTICS

Density comparisons

By running multiple queries, your AI calculates the total counts for different regions. You'll see which states or countries have the highest concentration.

ANALYSIS

Type distribution

The AI compares how many microbreweries versus brewpubs exist in a specific area. This helps you understand the local market makeup.

HUMAN

Strategic decisions

The AI provides the numbers, but you decide how to use that data for your business plans. You handle the actual strategy.

The workflow

What your AI does when the request arrives.

The AI acts as a bridge between your questions and the Open Brewery DB.

  1. Identify the region

    The AI determines if you are asking about a specific country or a single state to narrow the search scope.

    get_breweries_by_countryget_breweries_by_state

  2. Filter by category

    Once the region is set, the AI isolates specific brewery types like brewpubs or taprooms.

    get_breweries_by_type

  3. Aggregate counts

    The AI tallies the results from the database to provide the exact numbers you asked for.

    get_breweries_by_state

  4. Compare datasets

    The AI looks at the results from different queries to highlight differences in density or type distribution.

    get_breweries_by_countryget_breweries_by_type

Try it

Copy these to start.

Use these prompts to begin your analysis.

Starting points

Swap out the specific states, countries, or brewery types for the ones you actually want to research.

Open Brewery DB Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_7uRL7Dk9Jau1kPKRNEc1QhMYb5pu1wtxpfCtsPCt/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — Open Brewery DB capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "open-brewery-db-alternative-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_7uRL7Dk9Jau1kPKRNEc1QhMYb5pu1wtxpfCtsPCt/mcp"
    }
  }
}
Copy into chat04

  • How many breweries are there in California?

  • Compare the number of brewpubs in Colorado versus Oregon.

  • List all breweries in Germany and tell me how many are microbreweries.

  • Which state in the US has the highest density of taprooms?

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect Open Brewery DB once, then ask.

Click the link to connect the MCP to your AI client. Your credentials stay encrypted, and you can start querying immediately.

Connect Open Brewery DB to your AI

FAQ

How this task behaves.

  • 01

    Can the AI add new breweries to the database?

    No. This MCP only allows the AI to read and query existing data from the Open Brewery DB.

  • 02

    Can I export the results to a spreadsheet?

    The AI can format the data as a table or a CSV-style list for you to copy, but it cannot directly write files to your hard drive.

  • 03

    Does the AI provide real-time updates?

    Yes, the AI queries the database live, so you get the most current information available in the Open Brewery DB.

  • 04

    Can the AI predict future brewery openings?

    No. The tools are limited to retrieving existing records; they cannot perform predictive modeling or forecasting.

  • 05

    Can I filter by brewery name?

    No. The available tools are designed to filter by state, country, or brewery type only.

  • More questions about Open Brewery DB? The Connector page answers them. See everything the Open Brewery DB Connector can do

Connect Open Brewery DB to Claude, Cursor, ChatGPT & more