Skip to content

motherduckdb/agent-skills / plugins/motherduck-skills-copilot/skills/motherduck-partner-delivery

motherduck-partner-delivery

Verified

Standardize MotherDuck delivery for consultancies and agencies across client engagements with reusable provisioning, isolation, and handoff patterns.

artifacts/client_delivery_example.py

View on GitHub
import json
import sys
from pathlib import Path

import duckdb

sys.path.append(str(Path(__file__).resolve().parents[3]))

from scripts._lib.motherduck_artifact_utils import artifact_session


CLIENTS = [
    {"slug": "acme", "database": "customer_acme", "region": "us-east-1"},
    {"slug": "globex", "database": "customer_globex", "region": "eu-central-1"},
]


def fetch_rows(conn: duckdb.DuckDBPyConnection, sql: str) -> list[dict]:
    cursor = conn.execute(sql)
    columns = [col[0] for col in cursor.description]
    return [dict(zip(columns, row)) for row in cursor.fetchall()]


def main() -> None:
    with artifact_session(
        slug="motherduck-partner-delivery",
        database_keys=[client["database"] for client in CLIENTS],
    ) as session:
        conn = session.conn
        for client in CLIENTS:
            usage_table = session.table(client["database"], "main", "usage_daily")
            conn.execute(
                f"""
                CREATE TABLE {usage_table} (
                    usage_date DATE,
                    account_count INTEGER
                )
                """
            )
            conn.execute(
                f"""
                INSERT INTO {usage_table}
                VALUES ('2026-03-01', 12), ('2026-03-02', 14)
                """
            )

        result = {
            "backend": session.describe(),
            "delivery_pattern": "one database and service-account boundary per client",
            "clients": [],
        }
        for client in CLIENTS:
            actual_database = session.database_name(client["database"])
            result["clients"].append(
                {
                    **client,
                    "database": actual_database,
                    "tables": fetch_rows(
                        conn,
                        f"""
                        SELECT table_name
                        FROM duckdb_tables()
                        WHERE database_name = '{actual_database}'
                        ORDER BY table_name
                        """,
                    ),
                }
            )
        print(json.dumps(result, indent=2))


if __name__ == "__main__":
    main()
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 198kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 196kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 196kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 196kUpdated Claude CodeCodexVerifiedInstall