Terminal
Terminal/Skill
Create, consume, or manage MotherDuck data shares, including audience grants, table filters, and refresh policy.
By MotherDuck
Works with
npx skills add motherduckdb/agent-skills --skill motherduck-share-dataask_docs_question feature is available, use it before falling back to public docs.INCLUDE_PATTERNA working connection, the source database, and the intended audience. Reuse these from context; related skills are available for missing setup or SQL details.
ACCESS RESTRICTED plus GRANT READ ON SHARE ... TO ROLE ... for governed internal distribution. Use ACCESS ORGANIZATION only when the caller deliberately wants its legacy organization-wide behavior.INCLUDE_PATTERN when every recipient of one share should see the same table/view subset. Create separate shares when audiences need different subsets.UPDATE MANUAL when the recipient needs a stable snapshot or versioned delivery.ACCESS RESTRICTED or VISIBILITY HIDDEN when distribution should stay tightly controlled.INCLUDE_PATTERN as row-level or column-level security. It selects whole tables and views and requires native MotherDuck storage.INCLUDE_PATTERN.LIST SHARES or MD_INFORMATION_SCHEMA.OWNED_SHARES; for filtered shares, verify the stored pattern and consumer-visible catalog.ATTACH the shared database and query it read-only.ALTER SHARE ... SET|RESET INCLUDE_PATTERN for table/view scope changes. If the share uses UPDATE MANUAL, the owner runs UPDATE SHARE and consumers run REFRESH DATABASE when a new snapshot is ready.For answer, review, or planning requests, return the sharing design and SQL without provisioning. For create, update, grant, or revoke requests, perform the requested in-scope operation and validate the resulting access; ask before public exposure, destructive revocation, or unrelated grants.
Read only the reference sections needed for the current task.
references/SHARE_PLAYBOOK.md for the full SQL playbook, role grants, include-pattern rules, access/update decisions, consumer workflow, and common failure modes.Load related skills only for missing capabilities; reuse established context.
motherduck-connect for MotherDuck authentication and connection setupmotherduck-explore for discovering databases, tables, columns, and existing sharesmotherduck-query for validating share SQL and downstream queriesmotherduck-duckdb-sql for DuckDB SQL syntax and lookup supportmotherduck-security-governance for role design and access-boundary review