INSTALL miniplot FROM community;
LOAD miniplot;

-- Arbitrary Plotly traces, layout and configuration as JSON
SELECT plotly_new_html(
    '[{"x":[1,2],"y":[3,5],"type":"scatter","name":"Series A"}]',
    '{"title":"Custom Plotly chart","showlegend":true}',
    '{"displayModeBar":false}'
);

-- Date values on a scatter axis; return HTML without opening a browser
SELECT scatter_chart_html(
    [DATE '2026-01-01', DATE '2026-01-02'],
    [10.0, 20.0],
    'Daily measurements'
);

-- Discover descriptions, parameter names and examples
SELECT function_name, description, parameters, examples
FROM duckdb_functions()
WHERE function_name IN ('plotly_new_html', 'scatter_chart_html');

-- Bar chart (opens in browser)
SELECT bar_chart(
    ['Q1', 'Q2', 'Q3', 'Q4'],
    [100.0, 150.0, 200.0, 180.0],
    'Quarterly Sales'
);

-- Line chart
SELECT line_chart(
    ['Mon', 'Tue', 'Wed', 'Thu', 'Fri'],
    [5000.0, 6500.0, 4800.0, 7200.0, 8500.0],
    'Weekly Revenue'
);

-- Scatter chart
SELECT scatter_chart(
    [1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0],
    [10.0, 25.0, 30.0, 45.0, 60.0, 75.0, 85.0, 95.0],
    'Performance vs Time'
);

-- Area chart
SELECT area_chart(
    ['Jan', 'Feb', 'Mar', 'Apr', 'May'],
    [1000.0, 1500.0, 1200.0, 1800.0, 2100.0],
    'Monthly Growth'
);

-- Save to file without opening browser
SELECT bar_chart(
    ['A', 'B', 'C'],
    [10.0, 20.0, 15.0],
    'Sample Chart',
    'output.html'
);

-- 3D Scatter chart
SELECT scatter_3d_chart(
    [1.0, 2.0, 3.0, 4.0, 5.0, 6.0],
    [2.0, 4.0, 1.0, 5.0, 3.0, 6.0],
    [3.0, 1.0, 4.0, 2.0, 5.0, 3.5],
    '3D Data Visualization'
);

-- Visualize CSV data
SELECT line_chart(
    list(month),
    list(sales),
    'Monthly Sales from CSV'
) FROM read_csv('sales.csv');