Business Intelligence Python Packages

dbt-core

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.

metricflow

MetricFlow allows you to define, build, and maintain metrics in code.

dbt-metricflow

MetricFlow allows you to define, build, and maintain metrics in code.

apache-superset-core

Apache Superset is a Data Visualization and Data Exploration Platform

dbt-metabase

dbt + Metabase integration

mindsdb

Platform dedicated to building an open foundation for applied Artificial Intelligence, designed for people seeking production-ready AI systems they can truly control, extend and deploy anywhere.

retentioneering

Retentioneering: product analytics, data-driven CJM optimization, marketing analytics, web analytics, transaction analytics, graph visualization, process mining, and behavioral segmentation in Python. Predictive analytics over clickstream, AB tests, machine learning, and Markov Chain simulations.

panel-graphic-walker

A project providing a Graphic Walker Pane for use with HoloViz Panel.

dqtlib

A Data Quality Tool that tells you what and surfaces the why

malloy

Python package for executing Malloy

orionbelt-semantic-layer-mcp

MCP server for the OrionBelt Semantic Layer — enables LLMs to explore semantic models, compile queries, and execute analytics via natural language.

datasette-dashboards

Datasette plugin to create interactive dashboards

databao-context-engine

Databao Context Engine is an open-source engine that automatically generates a governed semantic context from your databases, BI tools, documents, and spreadsheets. It runs locally in your environment and integrates with any LLM to deliver accurate, context-aware answers

dvt-ce

DVT — cross-engine data transformation tool with DuckDB federation.

apache-superset-extensions-cli

Apache Superset is a Data Visualization and Data Exploration Platform

databao

Databao agent is an open-source agent that enables you to chat with your data and receive answers in text, interactive charts, and tables.

scout-intel-mcp

The Google for AI agents — give Claude the power to research any company, analyze competitors, and track market trends. 6 tools, 5+ data sources, confidence-scored JSON. pip install scout-intel-mcp

databao-agent

Databao agent is an open-source agent that enables you to chat with your data and receive answers in text, interactive charts, and tables.

dbt-presto

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.

datafluent

Build a better understanding of your data in PostgreSQL.

briefer

Python notebooks and dashboards in a single place. Create powerful and flexible dashboards using code, or build beautiful Notion-like notebooks and share them with your team.

shotgrid-orm

This tool generates a SQAlchemy ORM for a Shotgrid schema

pivoteer

Inject pandas DataFrames into Excel templates with table resizing and pivot refresh.

mcp-server-excel-sql

Query Excel files with SQL through Claude - no SQL knowledge required. MCP server for AI-powered spreadsheet analytics.