Schema

What this skill does

The Schema skill maps the underlying SQLite database structure used to manage Instagram accounts, posts, comments, insights, and related metadata. It exposes the relational layout including key tables such as accounts, posts, comments, insights, user insights, hashtag searches, and an action log. This schema clarifies how Instagram content workflows and analytics are stored, linked by foreign keys with support for multi-account setups and content status tracking.

By understanding this schema, marketers can better interpret how data flows through Instagram publishing and engagement pipelines, track post statuses from draft to published, and analyze performance metrics at both media and account levels. The schema also reveals how templates and hashtag data are integrated into content management, enabling detailed audit trails and error tracking.

Who it's for

This skill is designed for growth leads and performance marketers who manage multiple Instagram accounts and need to integrate data-driven decisions into their content strategy. SEO/PPC operators working with social media campaigns will benefit from understanding the schema to correlate posting schedules and engagement metrics. Agency strategists overseeing client Instagram presences can use this schema to audit workflows, troubleshoot publishing errors, and optimize content templates systematically.

Key workflows

Practitioners typically begin by linking Instagram accounts, managing their access tokens and status through the accounts table. Next, content creation is tracked in the posts table, where media types, captions, hashtags, and templates are assigned, and post statuses are updated as they move from draft to published. Comments and replies are monitored via the comments table, enabling engagement tracking and response management.

Performance analysis involves querying the insights and user_insights tables to extract metrics like reach or engagement over specific periods. Hashtag effectiveness can be evaluated using the hashtag_searches table, while the action_log provides a record of automated or manual operations with their results and API rate limits, supporting troubleshooting and optimization.

Common questions

How does the schema support multi-account management? Each account is uniquely identified with foreign keys linking posts, comments, and insights, allowing independent or aggregated data views.

Can the schema track post publishing errors? Yes, the posts table includes an error message field that logs failures during publishing for diagnostics.

Are performance metrics stored at both post and account levels? The schema separates media-level insights from overall user insights, enabling detailed and aggregated performance analysis.

How to use in Metaflow

Attach the Schema skill to your Metaflow agent task to automatically access structured Instagram data reflecting content creation, publishing, and engagement workflows. Expect detailed relational mappings that support multi-account pipelines and status monitoring. This enables precise data queries and integrations for performance analysis and content optimization. For more detailed usage guidance, refer to the documentation on working with Instagram data schemas within Metaflow.

For broader context, see our roundup of claude marketing skills, and read Claude skills for SEO for related setup guidance.