Mathis Derenne
Community@mathisdrn · France
Data Science student. Open to freelance missions.
Agent Skills by Mathis Derenne
Showing 25 vetted skills indexed across 1 GitHub repositories.
mathisdrntroubleshooting-dbt-job-errors
Diagnose dbt Cloud job failures using run logs, Admin API, git history, and data investigation.
mathisdrnmalloy-debug
Diagnose and fix Malloy compile errors in .malloy files using IDE diagnostics.
mathisdrnmalloy-analyze
Explores data with Malloy queries and builds views, dashboards, and notebooks.
mathisdrnmalloy-notebooks
Create Malloy .malloynb notebooks for interactive dashboards and data stories.
mathisdrnmotherduck-model-data
Designs analytical database schemas and SQL data models in MotherDuck with a file-based project scaffold.
mathisdrndagster-expert
Provides expert guidance for building and managing Dagster data pipelines with the dg CLI.
mathisdrnfind-skills
Searches and installs agent skills from the open skills ecosystem using the Skills CLI.
mathisdrnmalloy-review
Reviews Malloy semantic-model files against rubrics and emits a structured Markdown review report.
mathisdrnduckdb-docs
Searches DuckDB and DuckLake documentation using BM25 full-text search against a locally cached index.
mathisdrnmalloy-model
Build Malloy semantic models with base sources, joined sources, and computed sources.
mathisdrnmotherduck-load-data
Load data into MotherDuck from files, object storage, dataframes, and external databases.
mathisdrnskill-creator
Create, evaluate, and iteratively improve Claude skills with benchmarked test runs.
mathisdrnmalloy-scope
Classifies discovered tables and proposes an analytical scope for Malloy data modeling.
mathisdrnmalloy-charts
Selects and configures Malloy chart annotations for data visualization rendering.
mathisdrnmalloy-patterns
Indexes Malloy documentation topics for lookup via the search_malloy_docs tool.
mathisdrnusing-dbt-for-analytics-engineering
Builds, tests, and validates dbt models using ref(), source(), and dbt show.
mathisdrnmalloy-discover
Profiles tables, columns, and relationships through Malloy queries before semantic modeling.
mathisdrnduckdb-scd
Implements Slowly Changing Dimensions Type 2 in DuckDB using MERGE INTO statements.
mathisdrnmalloy
Indexes and routes requests to Malloy modeling, analysis, and publishing skills.
mathisdrnmarimo-notebook
Write reactive marimo notebooks as Python files with correct cell structure.
mathisdrnmalloy-modeling
Build governed semantic data models in Malloy for the Malloy Publisher.
mathisdrnmalloy-queries
Write and debug Malloy queries using syntax rules, patterns, and error references.
mathisdrnmalloy-document
Adds #(doc) annotation tags to Malloy model sources and fields for natural-language search.
mathisdrnmotherduck-duckdb-sql
Provides DuckDB SQL syntax reference and MotherDuck-specific command guidance for writing and repairing queries.
Frequently Asked Questions About Mathis Derenne
FAQPage SchemaWhat tasks can I accomplish with mathisdrn's skill collection?▼
You can build and debug Malloy semantic models, queries, charts, and notebooks; author dbt models with ref()/source() and troubleshoot dbt Cloud job failures; load data into MotherDuck from S3, GCS, or local files; write DuckDB SQL including SCD Type 2; and get Dagster asset and pipeline guidance.
Who should use these data engineering skills?▼
Analytics engineers and data engineers working with the modern data stack: dbt practitioners debugging job failures, Malloy modelers building semantic layers and dashboards, DuckDB/MotherDuck users designing schemas or ingesting data, and Dagster developers managing assets, schedules, and sensors.
How do the Malloy skills work together in practice?▼
Start with malloy-discover to scan tables and relationships, then malloy-scope to propose an analytical focus, malloy-define for source plans and field definitions, and malloy-model to author .malloy files. Finish with malloy-queries, malloy-charts, and malloy-notebooks for analysis, visualization, and dashboards.
Are these skills free and open source?▼
The MotherDuck skills (model-data, load-data, duckdb-sql) carry an explicit MIT license. The dbt skills are authored by dbt-labs. Other skills in the manifest do not declare a license, so verify terms in each skill's repository before redistribution or commercial use.
What prerequisites or dependencies do these skills require?▼
dbt troubleshooting requires dbt Cloud/platform access with Admin API credentials; the analytics skill permits Bash(dbt), jq, and file operations. DuckDB SCD requires DuckDB v1.4.0+ for MERGE INTO. MotherDuck skills need cloud storage secrets or a Postgres endpoint. duckdb-docs uses Bash against a locally cached index.