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