The offdataai connector lets Claude work in your offdataai account. Ask it to design a data model and it draws the tables, columns and relationships in the Model Builder, where you can see and edit them. On higher plans it can also import a schema from a database you have connected and answer questions through your ontology.
Set it up
- In Claude, open Settings → Connectors. Find offdataai in the directory, or choose Add custom connector and enter
https://app.offdataai.com/mcp. - Click Connect. Claude opens offdataai; sign in (or create an account) and review what Claude will be able to do.
- Click Allow. You go back to Claude, and the offdataai tools are ready in your chats.
On a Claude Team or Enterprise plan, an Owner can add the connector for the whole workspace; each person still signs in to their own offdataai account.
What each plan includes
The connector follows your offdataai plan. Claude only sees the tools your plan includes.
- Explorer and Starter: the Model Builder. Claude can list, read, create, change and validate data models, add groups (subject areas) and sticky notes, and generate DDL. You see the latest version of each model.
- Pro and Founder's Lifetime: everything above, plus full version history with restore, and importing a model from a connected database. Pro also adds the ontology tools: business concepts, metrics, join paths, plain-English questions and read-only SQL.
- Team and Enterprise: everything in Pro, plus creating models in an organization or moving a model into one (editor role and above).
If you ask for something your plan doesn't include, Claude tells you which plan unlocks it. See pricing.
Try these
- “Design a star schema for an online store's orders, with customers, products and dates.”
- “Add a returns fact to my Retail model and group the sales tables into a Sales area.”
- “Check my Retail model for problems and fix what you find.”
- “Give me the Snowflake DDL for my Retail model.”
- “Import the schema from my Postgres connection into a new model.” (Pro)
- “Undo the last change Claude made to my Retail model.” (Pro)
Every change Claude makes returns a link to the model in the builder, and it updates live if you have it open.
Tools
Model Builder: list_models, get_model, create_model, update_model, validate_model, get_model_ddl, list_model_versions, restore_model_version, list_organizations, list_database_connections and import_model_from_database.
Ontology (Pro and above): list_ontologies, get_ontology, search_concepts, get_concept, join_path, get_query_context, query_ontology, ask_ontology, get_record, get_related_records, search_catalog, list_connections, run_query, the semantic-layer exports, and list_proposals, propose_concept and propose_relation.
What Claude can and can't change
- Model changes are saved as versions. On Pro and above you can restore any earlier version from the builder's History panel, or ask Claude to.
- Importing from a database reads table and column definitions and keys, never rows, and creates a new model; it doesn't change your database.
run_queryruns a single read-onlySELECTwith a timeout and a row cap. Claude can't write to your databases.- Claude can't edit an ontology directly. Its proposals wait in the review queue until a person accepts them.
- Running SQL and seeing unmasked personal data are separate permissions, off unless you turn them on at the consent screen.
Disconnect
Remove the connector in Claude's settings, or revoke it in offdataai under Settings → API keys. Revoking stops it working immediately; the models it created stay in your account.
Privacy
What Claude reads through the connector is the content of your offdataai account, and what it sends is what you asked it to build. We handle it as described in our Privacy Policy; Claude handles your conversations under Anthropic's terms.
Support
Questions or problems with the connector: contact@offdataai.com.
