FindSoftware

Records

Python library for running raw SQL queries against relational databases.

Records is a Python library that runs raw SQL and returns the results as rows. You write the SQL yourself and read the rows by column name, by index or as a dictionary. Queries can take named parameters and can be read from SQL files.

The README says the library is powered by SQLAlchemy and Tablib. Query results export through Tablib to CSV, JSON, YAML, spreadsheet and pandas DataFrame formats, and a command-line records tool exports query results as well.

Worth knowing

Database drivers are not included, so the driver for each database has to be installed separately.

Identity

Status
Active
Maintainer
Kenneth Reitz3
Maintained by
Individual
First release
20164

Rendering and deploy

Install with
pipenv2

Releases

Current major version
Pre-1.05
Last release
2024-03-295

Adoption

GitHub stars
7,2141
Contributors
456
Dependent repositories
2547
Dependent packages
117

Why these figures do not compare

Sources

  1. 2026-11-16: links, Written in, GitHub stars
    api.github.com/repos/kennethreitz/records
  2. 2026-11-16: links, Categories, Databases, Install with
    github.com/kennethreitz/records/blob/master/README.rst
  3. 2026-11-16: Maintainer, License, License model
    raw.githubusercontent.com/kennethreitz/records/master/LICENSE
  4. 2026-11-16: First release, Runtime
    pypi.org/pypi/records/json
  5. 2026-11-16: Current major version, Last release
    github.com/kennethreitz/records/releases/tag/v0.6.0
  6. 2026-11-16: Contributors
    api.github.com/repos/kennethreitz/records/contributors?per_page=1
  7. 2026-11-16: Dependent packages, Dependent repositories
    packages.ecosyste.ms/api/v1/registries/pypi.org/packages/records

Last reviewed · Listed since Edit on GitHubThis page as markdownas JSON