tentaclio

What it is and what it does

Tentaclio is a Python library that abstracts away the differences between reading and writing data across multiple storage backends—local files, FTP, SFTP, S3, HTTP/HTTPS, and databases—by exposing a single unified interface. Instead of learning separate APIs for each protocol, you use `tentaclio.open()` for streams and `tentaclio.db()` for database connections, always working with standard file-like objects and connection clients.

The library handles credential management automatically through environment variables, supports pandas DataFrames directly (read and write CSV, Parquet, etc. to any backend), and provides filesystem-like operations such as `listdir`, `scandir`, and `walk` where the underlying protocol supports them. It includes built-in handlers for file, FTP, SFTP, HTTP, and HTTPS; additional schemes (S3, Google Cloud Storage, Databricks, Snowflake, etc.) are available through optional companion packages. Designed for distributed data tasks, it reduces boilerplate and credential-handling complexity in data pipelines.

Use it for

• Read CSV or Parquet files from S3 or SFTP into pandas DataFrames without writing protocol-specific code.
• Write processed data to multiple backends (local, S3, database) using the same `tentaclio.open()` call with different URLs.
• Manage credentials centrally via environment variables instead of hardcoding or passing them through application code.
• Copy or move files between different storage systems (e.g., local to S3, SFTP to database) with a single `tentaclio.copy()` call.
• Query databases and write results to cloud storage in a single script without managing separate connection objects.
• List or walk remote directories on S3 or SFTP using familiar Python filesystem patterns.

Worth the install?

AI-flagged interpretation of the facts on this page. Verify before relying on it.

Install

tentaclio on PyPI

Before you install

Low friction installation with a pure-Python wheel. Active maintenance—released 9 days ago with a recent commit on 2026-08-05. Depends on seven well-established libraries (urllib3, requests, sqlalchemy, paramiko, pandas, click, pyyaml), all standard in data workflows.

Requires Python 3.10 or later. S3, Google Cloud Storage, Google Drive, and some database schemes require optional extra packages (tentaclio-s3, tentaclio-gs, tentaclio-gdrive, etc.). Credentials for protected resources must be configured via TENTACLIO__CONN__* environment variables.

License in practice

MIT license is permissive; you can use, modify, and distribute tentaclio freely in commercial and private projects with minimal restrictions.

Quickstart

pip install tentaclio

import tentaclio

# Read from S3
with tentaclio.open("s3://my-bucket/file.txt") as reader:
    contents = reader.read()

# Write to SFTP
with tentaclio.open("sftp://host/path/file.txt", mode="w") as writer:
    writer.write(contents)

Package facts

Evidence: tentaclio-1.5.1-py3-none-any.whl

Tags

More Database packages

See also tentaclio-postgres · tentaclio-s3 · s3path · dbstream · smart-open · sftpretty · universal-pathlib · awswrangler · fs-s3fs · s3fs