Notion Connector

Notion is an all-in-one workspace for notes, documents, databases, and collaboration, designed for flexibility and productivity.

Start for free View documentation

4.8 on G2

Weld · Data Sources

NotionYour warehouseLive

database25 columnsSynced

page21 columnsSynced

data_source19 columnsSynced

data_source_property7 columnsSyncing

page_property5 columnsQueued

Lands in

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

Notion

Data source

Authenticating...

Ready to connect

Overview

Notion in your warehouse.
Ready for your agents.

Notion is an all-in-one workspace for notes, documents, databases, and collaboration, designed for flexibility and productivity. Weld's Notion connector is fully managed: it extracts data from Notion, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.

Agent context

Notion data schema.
The map your agents read.

Every table, field and relationship Weld syncs from Notion is served to agents as context over MCP, so they pick the right tables and join on the right keys.

tables: 5
fields: 77

Open the schema explorer Open the full schema explorer

Weld MCP server

Ask your agent.
It already knows Notion.

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Notion context, finds the tables it needs and queries your warehouse.

Agent contextNotion tables, fields and joins
QuerySQL against your warehouse
OperateCheck, rerun and refresh syncs

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextNotiontables5fields77

How many data_source rows do we have per database? Use our Notion data.

Reading the Notion context first, so the query uses the right tables and keys.

●weld·search_available_references

⎿raw.notion.data_source

raw.notion.database

+ 3 more Notion tables

●weld·get_reference_schema

⎿data_source · 19 columns

joins database on parent_database_id

●weld·run_query

⎿select j.id, count(*) from {{raw.notion.data_source}} d

join {{raw.notion.database}} j on d.parent_database_id = j.id

group by 1

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Notion data in your warehouse

>Ask about your Notion dataMCP

Destinations

Load Notion into any warehouse.
Set up in minutes, no code.

Resources

Everything you need.
To get started.

Documentation

Notion setup guide

Step-by-step instructions to configure and start syncing.

MCP server

Connect your agents

Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.

Weld Connect API

Build custom connectors

Use the Weld Connect API to build and publish your own connector.

FAQ

Common questions

Answers to frequently asked questions about Weld connectors.

Weld Connect API

Set it up in code.
One REST API.

Use the Weld Connect REST API to create Notion connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a Notion ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "notion",
    "destination_schema_name": "notion_data",
    "sync_interval": "0 * * * *"
  }'
▌