edit_flight_source
Edit Flight Source
Edit a Flight's source code with find-and-replace operations, producing a new version.
Supported Tools
get_query_guide
Get Query Guide
Load your organization's query guidance and an overview of available Guides before writing SQL.
query
Query
Execute read-only SQL queries against MotherDuck databases.
run_flight
Run Flight
Trigger an on-demand execution of a Flight using its current version.
list_dives
List Dives
List all Dives in your MotherDuck workspace.
list_databases
List Databases
List all databases in your MotherDuck account.
get_flight
Get Flight
Fetch a Flight's metadata and version snapshot, optionally at a historical version.
cancel_flight_run
Cancel Flight Run
Cancel an in-progress Flight run.
search_catalog
Search Catalog
Fuzzy search across databases, schemas, tables, columns, and shares.
list_tables
List Tables
List tables and views in a MotherDuck database.
delete_flight
Delete Flight
Permanently delete a Flight, its versions, schedule, and run history.
list_columns
List Columns
List columns of a table or view with types and comments.
list_flight_runs
List Flight Runs
List the execution history of a Flight, newest first.
update_flight
Update Flight
Update a Flight's source, requirements, config, token, secrets, name, or schedule.
update_dive
Update Dive
Update an existing Dive's title, description, or content.
read_dive
Read Dive
Read a specific Dive by ID, including its full component code.
list_guides
List Guides
Browse your organization's Guides level by level, grouped by topic.
query_rw
Query Read Write
Execute SQL queries that can modify data or schema in MotherDuck.
create_guide
Create Guide
Create a markdown Guide that AI agents use to answer your organization's data questions.
set_guide_access
Set Guide Access
Change a Guide's visibility between private and organization-wide.
list_macros
List Macros
List table and scalar macros in a MotherDuck database with their parameters.
save_dive
Save Dive
Save a new Dive to your MotherDuck workspace.
list_flights
List Flights
List Flights with summary metadata, optionally filtered by keywords.
get_guide
Get Guide
Load a Guide's full content by UUID, optionally pinning a historical version.
view_dive
View Dive
Load a Dive's source, preview inputs, and MotherDuck app link for a live preview.
list_views
List Views
List views in a MotherDuck database with schema, comment, and column count.
delete_dive
Delete Dive
Permanently delete a Dive by ID.
list_flight_versions
List Flight Versions
List the version history of a Flight, newest first.
delete_guide
Delete Guide
Soft-delete a Guide while preserving its version history.
list_shares
List Shares
List database shares that have been shared with you.
get_flight_run_logs
Get Flight Run Logs
Fetch the logs and run record for a single Flight run.
update_guide_metadata
Update Guide Metadata
Change a Guide's title, description, or topic without creating a content version.
edit_guide_content
Edit Guide Content
Apply targeted string replacements to a Guide and save a versioned update.
get_current_user
Get Current User
Get the authenticated MotherDuck user, organization, and account region.
create_flight
Create Flight
Create a new Flight from Python source code, requirements, and an optional schedule.
update_guide
Update Guide
Append a version to an existing Guide with updated content or references.
More integrations teams use with Motherduck
GitHub
Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.
Salesforce
Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Subscribe to real-time change events via Change Data Capture and Platform Events. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.
Sharepoint
Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Resolve site users to numeric Person/Group LookupId values. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Subscribe to webhooks for list and library change notifications. Retrieve site properties and search for sites across Microsoft 365.
Airtable
Create, read, update, and delete records in Airtable bases and tables. Manage base schemas including creating tables and fields. Filter records using formulas, sort by fields, and scope queries to specific views. Upsert records to find, create, or update in a single call. Upload attachments to records, read and write record comments, list accessible bases, and receive real-time base change events through webhooks.
Sentry
Track, manage, and resolve application errors and performance issues. List, query, and bulk-update issues and error events with filters like status, assignment, and tags. Create and manage releases, associate commits, and upload source maps. Configure issue alert rules and metric alert rules with notification actions. Set up cron monitors to detect missed or failed scheduled jobs. Build custom dashboards with configurable widgets. Run ad-hoc Discover queries across errors and transactions for performance analysis. Manage organizations, teams, projects, and members. Provision users via SCIM. Access session replay data. Receive webhooks for issues, errors, alerts, comments, and installation events.
Bitbucket
Manage Git repositories, pull requests, and CI/CD pipelines on Bitbucket Cloud. Create, fork, and configure repositories within workspaces and projects. Create, review, approve, merge, and decline pull requests with inline code comments. Browse source code, list commits, and manage branches and tags. Trigger, monitor, and manage Bitbucket Pipelines. List workspace members, configure repository default reviewers and branch restrictions, create and manage repository webhooks, and search code across repositories.
Technical notes for Motherduck
Query MotherDuck databases, explore catalogs, and manage Dives, Flights, and Guides through native SQL and the PostgreSQL endpoint.
Frequently asked questions
Common questions about connecting Motherduck to AI agents with Metorial.
Can Metorial connect Motherduck to AI agents?
Yes. Metorial connects AI agents to Motherduck through a governed integration layer, so teams can use the provider while keeping access controlled and observable.Does the Motherduck integration work with MCP?
Metorial is MCP compatible and lets teams expose approved provider tools to MCP-capable agents and clients through a controlled access layer.How does Metorial control access to Motherduck?
Metorial applies policies across users, groups, providers, agents, and individual tools, then records the context around every agent interaction.Can teams trace Motherduck activity from agents?
Yes. Metorial records provider activity so teams can inspect tool calls, troubleshoot integrations, and give security teams the visibility they need.