Now v1.0 available

Data Analytics
Made Simple.

A lightweight Python framework to bridge the gap between complex data warehouses and actionable analytics. Open-source, modular, and fast.

Get Started
$ pip install db-analytics-tools
db_tools start --config config.json --address 127.0.0.1 --port 8050
UI Screenshot

About the Project

Empowering Data Teams with Simplicity

DB Analytics Tools was born from a simple observation: modern data stacks are often too heavy for agile teams who need to move fast. Our framework focuses on the essentials: connectivity, extraction, and transformation.

Whether you are working with PostgreSQL, MySQL, or cloud data warehouses, we provide a unified interface that eliminates boilerplate code and lets you focus on the logic of your data.

100%
Open Source
Light
Weight Core

Automated ETL

Scheduled extractions without the headache.

Secure Auth

Robust secret management integrated.

Instant Connectivity

Stop wasting time with complex boilerplate. Connect and query in seconds.

Two instructions to connect to any DB: Python
import db_analytics_tools as db

client = db.Client(
    host=HOST, 
    port=PORT, 
    database=DATABASE, 
    username=USER, 
    password=PASSWORD, 
    engine=ENGINE
)

Supports PostgreSQL, Greenplum and SQL Server.

Core Components

Modular architecture designed to handle every step of your data pipeline.

DB Client

A high-level wrapper around SQL engines. Execute queries, manage sessions, and retrieve DataFrames with a single method call.

ETL Engine

Automate the flow of data. Built-in functions for incremental loads, streaming extraction, and schema management.

DataViz

Turn raw data into insights. Integration with top charting libraries to generate professional reports directly from your datasets.

ML

Standardized machine learning workflows. Simplified training, evaluation, and deployment of models within your data ecosystem.

Airflow

Native Airflow integration. Orchestrate your tasks with ease using our custom operators and REST API wrappers.

UI

A ready-to-use administration console built with Streamlit to monitor your pipelines and visualize your database health.

Pricing Plans

Choose the right path for your project or organization.

Individual & OSS

$0 / forever

Perfect for individual contributors, researchers, and small open-source projects.

  • Full framework access
  • MIT Licensed
  • Community Support
Custom
Enterprise

From $100 / month

Tailored solutions for teams requiring priority support and specialized services.

  • Advanced UI
  • Priority Feature Development
  • On-premise setup assistance
  • Dedicated Support (SLA)
  • Airflow Deployment