agate-sql

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

agate-sql extends the agate data analysis library with the ability to read from and write to SQL databases, bridging in-memory tabular data with relational database backends.

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

pip install agate-sql

uv add agate-sql

poetry add agate-sql

Installing agate-sql

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

Evidence: agate_sql-0.7.3-py3-none-any.whl

Tags

More Python Modules packages