A micro Python framework to simplify analytics tasks.
Open-source, modular and fast.
pip install db-analytics-tools
DB Analytics Tools is designed and maintained by Joseph Konka, a Data Science professional with a strong passion for the Python ecosystem.
The project's journey began in 2022 at Togocom. Faced with the need to automate SQL functions execution, Joseph built a set of core foundational scripts to drastically boost workflow efficiency.
This codebase was initially packaged as SQL ETL Runner to standardize agile data pipelines. Over time, it continued to evolve modularly, transforming into the comprehensive open-source framework it is today: Databases Analytics Tools.
Writing the first custom Python scripts to automate workflows and eliminate time-consuming manual interventions.
Standardizing the internal automation codebase into a modular Python package dedicated to lightweight and agile ETL processes.
A complete upgrade into a universal, open-source, and modular framework, now featuring a dedicated user interface via Docker.
Stop wasting time with complex boilerplate. Connect and query in seconds.
import db_analytics_tools as db
client = db.Client(
host=HOST,
port=PORT,
database=DATABASE,
username=USER,
password=PASSWORD,
engine=ENGINE
)
docker run -p 8050:8050 \
--restart=always \
--mount type=bind,source=./config.json,target=/app/config.json \
--mount type=volume,source=db_cron_data,target=/var/spool/cron/crontabs \
--name db-analytics-tools-ui-1 \
-d joekakone/db-analytics-tools-ui:latest
# Use Docker Compose - Download the docker-compose.yml file
# https://github.com/joekakone/db-analytics-tools/blob/master/docker-compose.yml
docker compose up -d
Supports PostgreSQL, Greenplum and SQL Server.
Modular architecture designed to handle every step of your data pipeline.
A high-level wrapper around SQL engines. Execute queries, manage sessions, and retrieve DataFrames with a single method call.
Automate the flow of data. Built-in functions for incremental loads, streaming extraction, and schema management.
Turn raw data into insights. Integration with top charting libraries to generate professional reports directly from your datasets.
Standardized machine learning workflows. Simplified training, evaluation, and deployment of models within your data ecosystem.
Native Airflow integration. Orchestrate your tasks with ease using our custom operators and REST API wrappers.
A ready-to-use administration console built with Streamlit to monitor your pipelines and visualize your database health.
Deploy the free open-source framework or leverage expert data services for your business.
Perfect for data engineers, developers, and teams looking to automate pipelines without boilerplate overhead.
Peace of mind for businesses running DB Analytics Tools in critical production environments.
End-to-end data engineering expertise to build, optimize, and scale your modern data stack.
DB Analytics Tools is free and community-backed. If this framework saves your team hours of boilerplate code and production headaches, consider supporting its independent development.