motherduckdb/motherduck-explore
skills/motherduck-explore/SKILL.md
Discover and explore databases, tables, columns, and data shares in MotherDuck. Use when you need to understand what data is available, preview table contents, or search the data catalog.
$ install --global
skillsauthnpx skillsauth add motherduckdb/agent-skills motherduck-exploreInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Jun 11, 2026, 2:35 AM59.1s2 files scanned
SKILL.md
- name:
- motherduck-explore
- description:
- Discover and explore databases, tables, columns, and data shares in MotherDuck. Use when you need to understand what data is available, preview table contents, or search the data catalog.
- license:
- MIT
Explore MotherDuck Data
Use this skill when you need to discover what databases, tables, and columns exist in a MotherDuck account; preview and sample data; understand schemas and data types; find shared databases; or search the data catalog.
Prerequisites
- An established MotherDuck connection (or an active MotherDuck MCP server)
Default Posture
- Explore top-down: databases, then tables/views, then columns, then statistics, then sample rows.
- Use fully qualified table names once more than one database is attached.
- Check shared databases before concluding that data is unavailable.
- Use the MotherDuck MCP tools (
list_databases,list_tables,list_columns,search_catalog) when available because they return structured results faster than ad hoc SQL. - Return a concise schema map with table grain, join keys, date columns, and likely measures before moving into modeling or dashboard work.
Workflow
- List databases in scope.
- List tables and views in the target database.
- Inspect columns, types, nullability, and comments before writing queries.
- Run
SUMMARIZEon important tables to understand ranges, cardinality, and null rates. - Preview rows, capture grain and join assumptions, and only then move into analytical SQL or modeling work.
Open Next
- Read
references/EXPLORATION_PLAYBOOK.mdfor the full SQL workflow, share discovery patterns, MCP tool guidance, and common exploration mistakes
Related Skills
motherduck-connectfor session setup and authenticationmotherduck-queryfor analytical SQL after the schema is understoodmotherduck-duckdb-sqlfor DuckDB syntax patterns during explorationmotherduck-share-datafor creating and consuming shares once shared datasets become part of the workflow
Related Skills
motherduckdb/motherduck-create-flight
development
VerifiedTrustedCommunity
Create, schedule, run, and debug MotherDuck Flights — Python jobs that run on MotherDuck compute. Use whenever someone wants to create a flight, schedule a Python script or recurring job on MotherDuck, set up scheduled ingestion from Postgres, dlt sources, S3, BigQuery, Snowflake, or APIs, refresh aggregates or transformations on a cron, or operate flights with get_flight_guide, create_flight, run_flight, flight logs, secrets, schedules, and versions.
30SKILL.mdUpdated Jun 11, 2026
motherduckdb/motherduck-create-flight
development
VerifiedTrustedCommunity
Create, schedule, run, and debug MotherDuck Flights — Python jobs that run on MotherDuck compute. Use whenever someone wants to create a flight, schedule a Python script or recurring job on MotherDuck, set up scheduled ingestion from Postgres, dlt sources, S3, BigQuery, Snowflake, or APIs, refresh aggregates or transformations on a cron, or operate flights with get_flight_guide, create_flight, run_flight, flight logs, secrets, schedules, and versions.
30SKILL.mdUpdated Jun 11, 2026
motherduckdb/motherduck-share-data
data-ai
VerifiedTrustedCommunity
Create and manage MotherDuck data shares for zero-copy, read-only data distribution. Use whenever someone wants to share a database with team members, another organization, or the public — covers CREATE SHARE, access/visibility/update modes, GRANT READ ON SHARE, attaching share URLs, UPDATE SHARE, and REFRESH DATABASE.
30SKILL.mdUpdated May 7, 2026
motherduckdb/motherduck-security-governance
development
VerifiedTrustedCommunity
Explain MotherDuck security, governance, and access-control patterns. Use for any question about SOC 2, GDPR, compliance, data residency, regions, SSO, service accounts, token handling, tenant isolation, sharing boundaries, snapshots and recovery, or governance posture — including when a security_compliance_owner, technical_owner, or application_builder is evaluating MotherDuck.
30SKILL.mdUpdated May 7, 2026