# The United States' most popular databases by state going into 2022

> Part of Prisma's Data Guide. The complete index is at https://www.prisma.io/dataguide/llms.txt.

Want to know which databases are most popular throughout the US? Check out the map to see which is each state’s favorite - the results may surprise you!

Canonical URL: https://www.prisma.io/dataguide/just-for-fun/us-most-popular-databases-by-states
Authors: Alex Emerich
Content revision: 30f01088ca2ef88b652de6a1779f7f6a805cd0873c35f0d50852a15db5e28344
Source revision: 0b7b2c69a1257927596ec767e0011b7d9b9c99eb

> **This study is from 2022.** The results reflect data collected going into 2022, and the study hasn't been repeated since.

## Introduction

Databases, at their core, store and organize data to serve a multitude of purposes. To meet modern challenges, databases have evolved to include different types, functions, and features. A particular database may be the preferred option over another because of its unique capabilities or because of other databases’ limitations. This plethora of options makes it interesting to understand where different populations lean when selecting their database.

As a next-generation open-source ORM designed to abstract away the functions of traditional management systems to improve developer productivity, we at Prisma were curious to learn which databases are most predominant throughout the United States. So, we performed a bit of research on our own. Check out the map to see what database is each state’s favorite going into 2022 - the results may surprise you!

## Results

![United States' Top Databases going into 2022](https://www.prisma.io/dataguide/static/09d54a9b6eaeb67d4ff3e3be62ee6618/64756/US-top-dbs-map.png)

## Interesting finds

- Microsoft Access is the overall favorite database for the entire country, taking the top spot in 26 states.
- IBM Db2 came in dead last, with only two states (Minnesota & Wisconsin) claiming it as their top database pick.
- Three states tied for their favorite databases
  - Arizona tied between Microsoft SQL Server and Microsoft Access
  - Virginia tied between MySQL, Microsoft SQL Server, and Elasticsearch
  - District of Columbia tied between Oracle, PostgreSQL, and Microsoft Access
- 33 states’ favorite databases are Microsoft-owned products.
- Redis is popular among coastal states like New York, California, and Washington.

## Methodology

We looked at the 10 most popular databases across the nation and analyzed their Google Trends search volume data over the past 12 months to determine each state’s favorite.

For each state, we observed, recorded, and compared the predominance of search activity for the following databases:

1. Oracle
2. MySQL
3. Microsoft SQL Server
4. PostgreSQL
5. MongoDB
6. Redis
7. IBM Db2
8. ElasticSearch
9. SQLite
10. Microsoft Access

| Region               | Database                                 |
| -------------------- | ---------------------------------------- |
| Alaska               | Microsoft Access                         |
| Alaska               | Microsoft Access                         |
| Arizona              | Microsoft SQL Server/ Microsoft Access   |
| Arkansas             | Microsoft Access                         |
| California           | Redis                                    |
| Connecticut          | MongoDB                                  |
| Delaware             | Microsoft Access                         |
| District of Columbia | Oracle/PostgreSQL/Microsoft Access       |
| Florida              | Microsoft Access                         |
| Georgia              | Microsoft Access                         |
| Hawaii               | Microsoft Access                         |
| Idaho                | MySQL                                    |
| Illinois             | Microsoft Access                         |
| Indiana              | Microsoft SQL Server                     |
| Iowa                 | Microsoft Access                         |
| Kansas               | Microsoft Access                         |
| Kentucky             | Microsoft Access                         |
| Louisiana            | Microsoft Access                         |
| Maine                | Microsoft Access                         |
| Maryland             | Microsoft Access                         |
| Massachusetts        | MySQL                                    |
| Michigan             | Microsoft SQL Server                     |
| Minnesota            | IBM Db2                                  |
| Mississippi          | Microsoft Access                         |
| Missouri             | Microsoft SQL Server                     |
| Montana              | Microsoft Access                         |
| Nebraska             | Microsoft Access                         |
| Nevada               | Microsoft Access                         |
| New Hampshire        | MySQL                                    |
| New Jersey           | MongoDB                                  |
| New Mexico           | SQLite                                   |
| New York             | Redis                                    |
| North Carolina       | MongoDB/SQLite                           |
| North Dakota         | Microsoft Access                         |
| Ohio                 | Microsoft SQL Server                     |
| Oklahoma             | Microsoft Access                         |
| Oregon               | SQLite                                   |
| Pennsylvania         | Microsoft Access                         |
| Rhode Island         | Microsoft Access                         |
| South Carolina       | Microsoft Access                         |
| South Dakota         | SQLite                                   |
| Tennessee            | Microsoft Access                         |
| Texas                | MongoDB                                  |
| Utah                 | SQLite                                   |
| Vermont              | SQLite                                   |
| Virginia             | MySQL/Microsoft SQL Server/ElasticSearch |
| Washington           | Redis                                    |
| West Virginia        | Microsoft Access                         |
| Wisconsin            | IBM Db2                                  |
| Wyoming              | Microsoft Access                         |