motherduckdb/agent-skills / plugins/motherduck-skills-copilot/skills/motherduck-partner-delivery
motherduck-partner-delivery
VerifiedStandardize MotherDuck delivery for consultancies and agencies across client engagements with reusable provisioning, isolation, and handoff patterns.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 4.4 KB |
| artifacts/client_delivery_example.py | script | 2.2 KB |
| artifacts/client_delivery_example.ts | script | 1.2 KB |
| references/EXECUTION_REFERENCE.md | markdown | 1.6 KB |
| references/PARTNER_DELIVERY_GUIDE.md | markdown | 9.3 KB |
artifacts/client_delivery_example.py
View on GitHubimport 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()
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 198k | Updated | Claude CodeCodex | Verified | Install |
| 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: 196k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |
| 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: 196k | Updated | Claude CodeCodex | Verified | Install |