Ross ROSS = Recommend OSS · open-source software intelligence for agents

yhat/db.py

db.py is an easier way to interact with your databases observed · 2026-08-28

github.com/yhat/db.py · Python · BSD-2-Clause (permissive) · archived observed · 2026-08-28

Health v2 · maintenance only

10/100

  • Activity 0
  • Release rhythm 35
  • Longevity 100

Flags: no_releases archived

How is this computed?

round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-02. Adoption (stars, forks) is never an input.

  • gap_med: n/a
  • age_days: 4329
  • days_rel: n/a
  • days_push: 1857
  • n_releases_24m: 0

Full methodology

Adoption not part of the score

1213 stars · 110 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

db.py is a Python library that provides a friendlier interface for interacting with relational databases like PostgreSQL, MySQL, SQLite, Redshift, SQL Server, and Oracle. It integrates tightly with pandas and IPython to make exploring tables, columns, and query results easy and visually pleasant.

Use cases

  • query a postgres database and get results as a pandas dataframe
  • explore database tables and columns interactively in a notebook
  • run sql files against a database from python
  • inspect table schemas with friendly formatted output
  • quickly prototype analytics queries against mysql or redshift

When to choose

  • you use pandas and want database results as dataframes with minimal boilerplate
  • you want an interactive, exploratory database experience in IPython or Jupyter
  • you need a simple unified interface across several relational databases

When to avoid

  • you need an actively maintained library - the last release was in 2021
  • you need async support, connection pooling, or an ORM with migrations
  • you work with non-relational databases like MongoDB or Cassandra

Facets

library · maturity maintenance

database database-driver databases data-science developer-tools python cross-platform pandas-integration sql ipython query-helper schema-exploration

2 sources

Member repositories

RepositoryRoleHealth v2
yhat/db.pymain10

For agents

markdown · JSON · MCP: product_card(name="yhat/db.py")

Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem