records
SQL for Humans
Decision gist · record as of 2026-08-14
Yes, if you prefer writing SQL directly and need a lightweight result wrapper with export capabilities. The permissive license, low install friction, and stable API make it a reasonable choice for simple query workflows. However, the aging maintenance status (868 days since last release) means you should verify compatibility with your specific database drivers and Python version before committing to production use.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires a database driver for your target database (e.g., psycopg2 for PostgreSQL, mysql-connector-python for MySQL); Records itself does not include drivers.
- Low install friction with a pure-Python wheel and four runtime dependencies.
- Maintenance is aging—last release was 868 days ago—but the repository remains active and the package is marked Production/Stable with 7220 GitHub stars.
License · maintenance · safety
ISC (permissive) — Licensed under ISC (permissive), allowing free use, modification, and distribution with minimal restrictions.
last release 2024-03-29 (868 days) · last repo commit 2026-02-09 · 7,220 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 268,909 downloads/mo, #8,266 on PyPI
Alternatives
Verify before relying
import records
db = records.Database('postgres://user:pass@localhost/dbname')
rows = db.query('SELECT * FROM users')
for row in rows:
print(row.name, row.email)- Whether the aging maintenance status (last release 868 days ago) affects compatibility with recent database driver versions.
- Performance characteristics for large result sets compared to other query libraries.
What it is and what it does
Records is a minimal SQL query wrapper built on SQLAlchemy and Tablib that lets you execute raw SQL against relational databases and work with results as Python objects. It supports Postgres, MySQL, SQLite, Oracle, RedShift, and MS-SQL through SQLAlchemy's driver ecosystem, and returns rows as Record objects accessible by attribute name, dictionary key, or index position.
The package is designed for developers who prefer writing SQL directly rather than using an ORM. Beyond basic querying, it includes transaction support, parameterized queries, bulk operations, and integration with Tablib for exporting results to CSV, JSON, YAML, XLS, XLSX, or Pandas DataFrames. A command-line tool is also available for ad-hoc query export.
Use it for
- Export database query results to CSV, JSON, or Excel for reporting or data sharing.
- Execute raw SQL queries and iterate over results without ORM overhead in data pipelines.
- Build command-line tools that query databases and format output in multiple formats.
- Access query results flexibly by column name, index, or dictionary key in the same workflow.
- Run parameterized queries safely against multiple database backends with a single API.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you prefer writing SQL directly and need a lightweight result wrapper with export capabilities.
The permissive license, low install friction, and stable API make it a reasonable choice for simple query workflows. However, the aging maintenance status (868 days since last release) means you should verify compatibility with your specific database drivers and Python version before committing to production use.
Install
records on PyPI
Before you install
Low install friction with a pure-Python wheel and four runtime dependencies. Maintenance is aging—last release was 868 days ago—but the repository remains active and the package is marked Production/Stable with 7220 GitHub stars.
Requires a database driver for your target database (e.g., psycopg2 for PostgreSQL, mysql-connector-python for MySQL); Records itself does not include drivers.
License in practice
Licensed under ISC (permissive), allowing free use, modification, and distribution with minimal restrictions.
Quickstart
import records
db = records.Database('postgres://user:pass@localhost/dbname')
rows = db.query('SELECT * FROM users')
for row in rows:
print(row.name, row.email)Verify before relying
- Whether the aging maintenance status (last release 868 days ago) affects compatibility with recent database driver versions.
- Performance characteristics for large result sets compared to other query libraries.
Package facts
| License | ISC permissive |
| Python support | Not specified |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 4 packagesSQLAlchemytablibopenpyxldocopt |
| Maintenance | Aging 868 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 268,909 / month, #8,266 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 5 - Production/StableIntended Audience :: DevelopersLicense :: OSI Approved :: ISC License (ISCL)Natural Language :: EnglishProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.4Programming Language :: Python :: 3.5Programming Language :: Python :: 3.6Programming Language :: Python :: 3.7Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9Programming Language :: Python :: Implementation :: CPython |
Evidence: records-0.6.0-py2.py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “raw SQL query interface”
- recordsRecords provides a lightweight SQL query interface for relational…
- databricks-sqlProvides a Python interface for querying and manipulating Databricks…
- pypika-tortoiseGenerates SQL queries programmatically for Tortoise ORM, providing a…
Give your agent the search over MCP, or paste the wish link into any chat.
More Database packages
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Python client library for connecting to and executing commands against Redis key-value stores, supporting both synchronous and asynchronous operations.
Install it if your application needs to interact with Redis; the only prerequisite is a running Redis server instance.
YDB Python SDK is the official client library for connecting to and querying YDB databases from Python applications.
Install it if you need to connect Python applications to YDB databases.
Connects Python applications to Snowflake data warehouses using the DB API 2.0 specification, enabling SQL queries, data transfers, and warehouse operations.
sqlparse tokenizes SQL text into a tree of statements, clauses, and expressions, and provides functions to split scripts, format queries, and inspect parsed tokens without validating dialect or syntax.
Install it if you need to manipulate, format, or analyze SQL text programmatically.
Provides base adapter protocols and shared functionality that database adapters use to integrate with dbt-core, handling connections, dialect translation, relation caching, and core interface management.
See also ipython-sql · SQLAlchemy · dataset · agate-sql · django-postgres-copy · mssql · sqlalchemy-solr · tablib · DrissionRecord · recordlinkage