Search Shortcut cmd + k | ctrl + k
miniplot

Replace pandas + matplotlib with just DuckDB - instant data visualization from SQL

Maintainer(s): nkwork9999

Installing and Loading

INSTALL miniplot FROM community;
LOAD miniplot;

Example

-- Bar chart example
SELECT bar_chart(
    LIST_VALUE('Q1', 'Q2', 'Q3', 'Q4'),
    LIST_VALUE(100, 150, 200, 180),
    'Quarterly Sales'
);

-- Line chart example
SELECT line_chart(
    LIST_VALUE('Mon', 'Tue', 'Wed', 'Thu', 'Fri'),
    LIST_VALUE(5000, 6500, 4800, 7200, 8500),
    'Weekly Revenue Trend'
);

-- Scatter plot example
SELECT scatter_chart(
    LIST_VALUE(1, 2, 3, 4, 5, 6, 7, 8),
    LIST_VALUE(10, 25, 30, 45, 60, 75, 85, 95),
    'Performance vs Time'
);

-- Area chart example
SELECT area_chart(
    LIST_VALUE('Jan', 'Feb', 'Mar', 'Apr', 'May'),
    LIST_VALUE(1000, 1500, 1200, 1800, 2100),
    'Monthly Growth'
);

About miniplot

Interactive chart visualization extension for DuckDB - bringing pandas + matplotlib style data visualization directly to SQL, without leaving your database.

Mission: Replace pandas + matplotlib with just DuckDB

Features:

  • Bar, Line, Scatter, and Area charts
  • Native GUI rendering using Rust/Iced
  • Simple SQL interface for direct visualization
  • Cross-platform support (macOS, Linux, Windows)

Note: Requires graphical environment. Charts open in separate native windows.

Added Functions

function_name function_type description comment examples
area_chart scalar NULL NULL  
bar_chart scalar NULL NULL  
histogram_chart scalar NULL NULL  
line_chart scalar NULL NULL  
miniplot scalar NULL NULL  
miniplot_openssl_version scalar NULL NULL  
scatter_chart scalar NULL NULL