agate-sql
agate-sql adds SQL read/write support to agate.
Decision gist · record as of 2026-08-14
Yes, if you are already using agate and need SQL database connectivity. The package has low installation friction, permissive licensing, and no known vulnerabilities. However, maintenance is aging (last release 242 days ago), so verify compatibility with your versions of agate and sqlalchemy before deploying to production.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Installation is straightforward with low friction; the package has two runtime dependencies and a pure-Python wheel.
- However, maintenance status is aging—the last release was 242 days ago—so expect slower response to issues or compatibility updates.
License · maintenance · safety
MIT (permissive) — MIT license is permissive, allowing commercial and private use with minimal restrictions; you may use, modify, and distribute agate-sql freely as long as you include the license notice.
last release 2025-12-15 (242 days)
0 known vulnerabilities (OSV.dev, 2026-08-14) · 357,325 downloads/mo, #7,270 on PyPI
Alternatives
Verify before relying
pip install agate-sql
import agate
import agate_sql
table = agate.Table.from_sql('SELECT * FROM my_table', connection_string)- Whether the package remains compatible with the latest versions of agate and sqlalchemy given the aging maintenance status.
- Specific SQL database engines or versions that are actively tested or supported.
- Whether agate itself remains actively maintained for your use case.
What it is and what it does
agate-sql is a plugin for the agate data analysis library that adds SQL database connectivity. It allows you to load data directly from SQL queries into agate's in-memory table format and write agate tables back to database tables, using sqlalchemy as the underlying database abstraction layer. The package is designed for developers and researchers who work with tabular data and need to move data between SQL databases and agate's analytical environment.
The package has been in development since 2015 and is classified as Beta. It supports Python 3.10, 3.11, 3.12, 3.13, and 3.14 on both CPython and PyPy. With low installation friction and no known security vulnerabilities, it integrates cleanly into existing agate workflows, though its aging maintenance status means you should verify compatibility with your specific agate and sqlalchemy versions before relying on it for production use.
Use it for
- Load query results from a SQL database into an agate table for statistical analysis or data cleaning.
- Export cleaned or transformed agate tables back to a SQL database for persistence or downstream processing.
- Bridge between SQL-based data pipelines and agate's analytical and reporting capabilities.
- Prototype data workflows that move between relational databases and in-memory tabular analysis.
- Integrate agate into existing applications that already use sqlalchemy for database access.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you are already using agate and need SQL database connectivity.
The package has low installation friction, permissive licensing, and no known vulnerabilities. However, maintenance is aging (last release 242 days ago), so verify compatibility with your versions of agate and sqlalchemy before deploying to production.
Install
agate-sql on PyPI
Before you install
Installation is straightforward with low friction; the package has two runtime dependencies and a pure-Python wheel. However, maintenance status is aging—the last release was 242 days ago—so expect slower response to issues or compatibility updates.
License in practice
MIT license is permissive, allowing commercial and private use with minimal restrictions; you may use, modify, and distribute agate-sql freely as long as you include the license notice.
Quickstart
pip install agate-sql
import agate
import agate_sql
table = agate.Table.from_sql('SELECT * FROM my_table', connection_string)Verify before relying
- Whether the package remains compatible with the latest versions of agate and sqlalchemy given the aging maintenance status.
- Specific SQL database engines or versions that are actively tested or supported.
- Whether agate itself remains actively maintained for your use case.
Package facts
| License | MIT permissive |
| Python support | Not specified |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 2 packagesagatesqlalchemy |
| Maintenance | Aging 242 days since the last release |
| First released | |
| Downloads | 357,325 / month, #7,270 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 4 - BetaIntended Audience :: DevelopersIntended Audience :: Science/ResearchLicense :: OSI Approved :: MIT LicenseNatural Language :: EnglishOperating System :: OS IndependentProgramming Language :: PythonProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Programming Language :: Python :: Implementation :: CPythonProgramming Language :: Python :: Implementation :: PyPyTopic :: Scientific/Engineering :: Information AnalysisTopic :: Software Development :: Libraries :: Python Modules |
Evidence: agate_sql-0.7.3-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 › “SQL database read write agate”
- agate-sqlagate-sql extends the agate data analysis library with the ability to…
- agate-dbfAdds read support for DBF (dBASE) files to the agate data analysis…
- agate-excelAdds Excel file (xls and xlsx) read support to the agate data…
Give your agent the search over MCP, or paste the wish link into any chat.
More Python Modules packages
Converts domain names between Unicode and ASCII-compatible encoding (Punycode) according to IDNA 2008 and Unicode Technical Standard 46, with security validation and broader script coverage than the standard library.
Install it if you work with internationalized domain names, need to validate domains, or use HTTP clients that depend on it transitively.
Setuptools is a Python build backend and package management tool that handles building, distributing, and installing Python packages, including support for C/C++ extension modules.
PyYAML parses and emits YAML 1.1 data format, enabling serialization and deserialization of configuration files and Python objects to and from human-readable YAML text.
Pydantic validates Python data structures against type hints, coercing and checking input at runtime to ensure it matches a declared schema.
Provides reusable metadata objects for use with PEP-593 `typing.Annotated` to express common constraints like bounds, collection sizes, and predicates on types.
Install it if you use or build libraries that need to express type constraints in a standardized, inspectable way—or if you want to annotate your own types with…
Provides runtime tools to inspect and introspect Python type annotations, enabling programmatic examination of type hints at execution time.
See also agate · agate-dbf · agate-excel · records · SQLAlchemy · snowflake-sqlalchemy · databricks-sql-connector · dataset · osquery · beam-nuggets