Clojure Write

The clojure-write skill enables AI agents to generate, edit, and execute Clojure code directly within the Metabase environment. It streamlines data analysis workflows by allowing agents to construct complex queries using the language's powerful functional programming features.

When to use it

• Generating dynamic SQL queries for intricate database aggregations that standard UI builders cannot handle.
• Automating repetitive data transformation tasks involving recursive logic or advanced set operations.
• Creating custom visualizations by writing specific Clojure scripts to format and render data.
• Debugging existing Metabase queries by rewriting them in Clojure to optimize performance or fix syntax errors.

Key capabilities

• Direct code generation for the Clojure programming language.
• Seamless integration with the Metabase query engine.
• Support for functional programming patterns within data analysis contexts.
• Execution of scripts to produce actionable insights from raw datasets.

Example prompts

• "Write a Clojure script to calculate the average revenue per user grouped by region and date."
• "Generate a query that filters sales records where the profit margin exceeds 20% and sorts them by total value."
• "Create a function to join the customers and orders tables, then count the number of active users per month."

Tips & gotchas

Ensure your Metabase instance has Clojure execution enabled before attempting to run generated scripts. While this skill excels at complex logic, verify that the resulting code aligns with your specific database schema and security policies.