Instagram Business Connector
Instagram Business is a platform tailored for businesses to promote their products, engage with their audience, and gain actionable insights.
Instagram BusinessYour warehouseLive
Agent context over MCPSet up in minutes.
No code, no maintenance.
Instagram Business
Data source
Instagram Business in your warehouse.
Ready for your agents.
Instagram Business is a platform tailored for businesses to promote their products, engage with their audience, and gain actionable insights. Weld's Instagram Business connector is fully managed: it extracts data from Instagram Business, 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.
Instagram Business data schema.
The map your agents read.
Every table, field and relationship Weld syncs from Instagram Business is served to agents as context over MCP, so they pick the right tables and join on the right keys.
- tables
- 7
- fields
- 97
Instagram Business models.
What the numbers mean.
Open-source SQL that turns the raw Instagram Business tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions, not guesses.
- Profile Overview ReportProfile overview report for Instagram Business integration. For each account and month it returns the average follows and followers count, the followers gained, the average daily reach and the number of taps on the links in the profile. The results are ordered by account and month.grain: account x month
- User Engagement and Outreach ReportGenerates a report on user engagement and outreach for an Instagram Business integration. For each account and month it returns the average follower count and its change from the previous month, the followers gained, the average daily reach, the profile link taps, and the average likes, comments, feed views and feed reach per post. The result is sorted by month and user ID.grain: account x month
- Media Performance ReportGenerates a media performance report for Instagram Business integration. It combines metrics from the media_history and media_insights tables to provide a comprehensive view of monthly media performance. The report includes metrics such as total media posts, likes, comments, carousel engagement, views and reach, reel likes, views and reach, and feed engagement, views and reach.grain: account x month the media was posted
- Media Insights Deep DiveRetrieves various metrics for different types of media posts (carousel, reel, story, feed). It also calculates engagement rates for each type of media. The template joins the media data with the media history table to include additional information such as caption, timestamp, media type, likes count, and comments count. The final result is sorted by month and media posted date in descending order.grain: one row per media post, dated by the month it was posted
- Growth AnalysisCalculates the growth rates of various metrics for an Instagram Business account. It retrieves monthly data on average followers, average follows, total feed engagement, total carousel engagement, and total reel likes. It then calculates the growth rate percentages for each metric compared to the previous month. The results are sorted by month in descending order.grain: account x month
- Engagment Metric AnalysisCalculates various engagement metrics for Instagram Business accounts on a monthly basis. It retrieves data such as the total number of media posts, likes, comments, feed engagement, carousel engagement, reel likes, reel comments, story replies, and story exits. Additionally, it calculates average engagement per post metrics, including average likes, comments, feed engagement, carousel engagement, reel likes, and reel comments per post. The results are ordered by month in descending order.grain: month the media was posted
Ask your agent.
It already knows Instagram Business.
Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Instagram Business context, finds the tables it needs and queries your warehouse.
- Agent contextInstagram Business tables, fields and joins
- QuerySQL against your warehouse
- OperateCheck, rerun and refresh syncs
How many media_insights rows do we have in our Instagram Business data?
Reading the Instagram Business context first, so the query uses the right tables and keys.
Load Instagram Business into any warehouse.
Set up in minutes, no code.
Instagram Business to Amazon Redshift
Instagram Business to Amazon Redshift Cluster
Instagram Business to Amazon S3
Instagram Business to Apache Iceberg
Instagram Business to Azure SQL Database
Azure Synapse
Instagram Business to ClickHouse- Instagram Business to Databricks
- Instagram Business to Google BigQuery
Everything you need.
To get started.
Instagram Business setup guide
Step-by-step instructions to configure and start syncing.
MCP serverConnect your agents
Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.
Weld Connect APIBuild custom connectors
Use the Weld Connect API to build and publish your own connector.
FAQCommon questions
Answers to frequently asked questions about Weld connectors.
Set it up in code.
One REST API.
Use the Weld Connect REST API to create Instagram Business connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.
▌Common questions.
About connectors.
Put your Instagram Business data to work.
Connect Instagram Business, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.
Source
