# Records

Python library for running raw SQL queries against relational databases.


Source: https://findsoftware.frbit.cloud/records/
Last reviewed: 2026-11-16
Listed since: 2026-11-16

## Record

### Links

- repository: https://github.com/kennethreitz/records
- docs: https://github.com/kennethreitz/records/blob/master/README.rst

### Identity

- status: active
- maintainer: Kenneth Reitz
- maintainerType: individual
- parent: unknown
- firstRelease: 2016
- hqCountry: unknown

### Kind

- category: library
- hosting: python
- language: python
- runtime: python
- runtimeMin: unknown
- basedOn: unknown

### Content

- contentStore: not applicable
- databases: postgres, mysql, sqlite, oracle, sqlserver
- adminUi: not applicable
- headlessApi: not applicable
- templating: not applicable
- i18n: not applicable

### Rendering and deploy

- runsAs: not applicable
- renderingModes: not applicable
- installMethod: pipenv

### License

- licenseModel: open-source
- license: ISC

### Releases

- currentMajor: 0
- latestReleaseDate: 2024-03-29

### Adoption

- githubStargazers: 7214
- packagistDownloads: not applicable
- npmWeeklyDownloads: not applicable
- contributors: 45
- pluginCount: unknown
- packagistMonthlyDownloads: unknown
- ecosystemsMonthlyDownloads: unknown
- httpArchiveSites: unknown
- wordpressActiveInstalls: unknown
- dependentRepos: 254
- dependentPackages: 11

### Sources

- urls: https://api.github.com/repos/kennethreitz/records (read 2026-11-16)
- urls: https://github.com/kennethreitz/records/blob/master/README.rst (read 2026-11-16)
- maintainer: https://raw.githubusercontent.com/kennethreitz/records/master/LICENSE (read 2026-11-16)
- firstRelease: https://pypi.org/pypi/records/json (read 2026-11-16)
- category: https://github.com/kennethreitz/records/blob/master/README.rst (read 2026-11-16)
- language: https://api.github.com/repos/kennethreitz/records (read 2026-11-16)
- runtime: https://pypi.org/pypi/records/json (read 2026-11-16)
- databases: https://github.com/kennethreitz/records/blob/master/README.rst (read 2026-11-16)
- installMethod: https://github.com/kennethreitz/records/blob/master/README.rst (read 2026-11-16)
- license: https://raw.githubusercontent.com/kennethreitz/records/master/LICENSE (read 2026-11-16)
- licenseModel: https://raw.githubusercontent.com/kennethreitz/records/master/LICENSE (read 2026-11-16)
- currentMajor: https://github.com/kennethreitz/records/releases/tag/v0.6.0 (read 2026-11-16)
- latestReleaseDate: https://github.com/kennethreitz/records/releases/tag/v0.6.0 (read 2026-11-16)
- githubStargazers: https://api.github.com/repos/kennethreitz/records (read 2026-11-16)
- contributors: https://api.github.com/repos/kennethreitz/records/contributors?per_page=1 (read 2026-11-16)
- dependentPackages: https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/records (read 2026-11-16)
- dependentRepos: https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/records (read 2026-11-16)

## Notes

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.

---

Data licensed CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Attributes are recorded, never scored; absent means unknown.
Credit, in full: FindSoftware, CC BY 4.0
