Skip to content

Open-source agentic AI Search Execution Platform. Track AI visibility, find opportunities, and let agents turn signals into prioritized actions and drafted fixes across ChatGPT, Claude, Gemini, Google AI Overviews, Google AI Mode, Perplexity, Grok, and Microsoft Copilot.

NameLast commit date
..
00001_initial_schema.sql
00002_team_invitations.sql
00003_api_keys.sql
00004_prompt_competition.sql
00005_prompt_results_shopping_cards.sql
00006_insights_aggregates.sql
00008_visibility_trend_aggregates.sql
00009_agent_chat_schema.sql
00010_org_anthropic_keys.sql
00011_prompt_result_shopping_cards.sql
00012_shopping_mode.sql
00013_prompt_performance_aggregates.sql
00014_security_invoker_rpcs.sql
00015_brief_usage.sql
00016_enable_rls_exposed_tables.sql
00017_site_audit.sql
00018_site_audit_recommendations.sql
00019_site_audit_usage.sql
00020_brand_is_active.sql
00021_prompt_results_search_queries.sql
00022_fanout_query_intents.sql
00023_reports.sql
00024_tracked_prompt_count.sql
00025_prompt_visibility_summaries.sql
00026_insights_filter_options.sql
00027_visible_prompt_stats.sql
00028_competitor_visible_prompts.sql
00029_provider_visible_prompts.sql
00030_topic_suggestions.sql
00031_prompt_workflow.sql
00032_target_url_cited_stats.sql
00033_insights_sentiment_denominator.sql
00034_prompt_visibility_summary_citations.sql
00035_competitor_aggregates_live_only.sql
00036_daily_pulse.sql
00037_prompt_visibility_summary_rate.sql
00038_mention_position.sql
00039_visibility_rate_trend.sql
00040_ai_visibility_aggregates.sql
00041_prompt_visibility_summary_date_to.sql
00042_visibility_rate_trend_position_n.sql
00043_brand_state.sql
00044_tracking_runs.sql
00045_integration_connections.sql
00046_brand_gsc_property.sql
00047_gsc_query_stats.sql
00048_gsc_suggestion_support.sql
00049_cloro_pending_tasks.sql
00050_content_opportunity_aggregates.sql
00051_brand_ga_property.sql
00052_sent_pulses_window_dedupe.sql
00053_ga_traffic_stats.sql
00054_prompt_suggestions_ga_source.sql
00055_prompt_visibility_summaries_date_to.sql
00056_page_opportunities.sql
00057_topics_overview_aggregates.sql
00058_prompt_result_citations.sql
00059_citation_url_ids.sql
00060_citation_url_ids_variable_conflict.sql
00061_citations_aggregate_rpcs.sql
00062_organization_client_write_guard.sql
00063_report_aggregate_rpcs.sql
00064_report_query_fanout_rpc.sql
00065_report_query_fanout_engines.sql
00066_insights_daily_rollups.sql
00067_citation_url_detail_rpcs.sql
00068_citation_gap_rpcs.sql
00069_citations_rpc_org_guard.sql
00070_org_prompt_location_usage.sql
00071_prompt_state_locations.sql
00072_prompt_visibility_summaries_region.sql
00073_clear_derived_logo_urls.sql
00074_apply_prompt_locations.sql
00075_page_opportunity_citation_state.sql
00076_citations_urls_scope.sql
00077_citations_rpcs_custom_plan.sql
00078_kpi_definitions.sql
00079_signals.sql
00080_signals_summary_cards.sql
00081_actions.sql
00082_action_center_write_policies.sql
00083_action_task_editing.sql
00084_action_lifecycle.sql
00085_action_validation.sql
00086_action_definition_version.sql
00087_signal_runs.sql
00088_action_task_plan.sql
00089_action_candidates.sql
00090_action_task_runs.sql
00091_action_engine_detector_reads.sql
00092_action_engine_owned_citations_fast.sql
00093_task_modes_per_spec.sql
00094_task_modes_transition_window.sql
00095_action_engine_citation_sources_fast.sql
00096_task_modes_drop_transition_vocabulary.sql
00097_action_engine_prompt_answer_counts.sql
00098_topics_overview_competitor_rollup.sql
00099_content_aggregates_prompt_filter.sql
00100_service_role_statement_timeout.sql
00101_prompt_clusters.sql
00102_cluster_opportunities.sql
00103_cluster_opportunity_list.sql
00104_site_pages.sql
00105_opportunity_decision.sql
00106_opportunity_lifecycle.sql
00107_citations_domains_fast.sql
00108_health_probe.sql
00109_citations_urls_fast.sql
00110_competitor_aggregates_work_mem.sql
00111_citations_open_ended_date_to.sql
00112_visibility_trend_materialize.sql
00113_competitor_aggregates_custom_plan.sql
00114_opportunity_status_since_reopen.sql
00115_shopping_overview.sql
00116_opportunity_basket_metrics.sql
00117_delete_brand_results_batch.sql
00118_citations_daily_rollups.sql
00119_citations_urls_daily_definer.sql
00120_prompt_improve_suggestions.sql
00121_prompt_improve_actions.sql
00122_import_prompts.sql
00123_prompt_position_summaries.sql
00124_prompt_improve_outcome.sql
00125_opportunity_usage.sql
00126_opportunity_source.sql
00127_opportunity_suggested_filter.sql
00128_count_active_prompt_locations.sql
00129_insights_breakdown_groups.sql
00130_insights_same_prompts.sql
00131_insights_kpi_cards.sql
00132_insights_platform_compare.sql
00133_insights_platform_table.sql
00134_starter_copilot.sql
00135_insights_change_drivers.sql
00136_insights_trend.sql
00137_insights_topic_competitors.sql
00138_prompt_suggestion_relevance.sql
00139_prompt_usage_counters.sql
00140_fanout_coverage_by_platform.sql
00141_signal_groups.sql
00142_competitor_signal_positions.sql
00143_traffic_signal_evidence.sql
00144_action_priority_score.sql
00145_action_signals.sql
00147_insights_same_prompts_definer.sql
00148_insights_change_drivers_definer.sql
00149_insights_kpi_same_prompts_definer.sql
00150_action_task_writer.sql
00151_opportunity_source_action.sql
00152_insights_topic_competitors_definer.sql
00153_prompt_position_summaries_json.sql
00154_prompt_volume_median.sql
00155_ai_volume_multiplier_45.sql
00156_topics_overview_window.sql
00157_mentions_daily.sql
00158_mentions_list.sql
00160_mention_sentiment_override.sql
00161_mentions_perception.sql
00162_refresh_insights_daily_range.sql
00163_kpi_presets.sql
00164_insights_topic_rollups.sql
00165_site_audit_page_prefs.sql
00166_audit_competitor_cited_prompts.sql
00167_site_audit_auto.sql
00168_actions_soft_delete.sql
00169_head_to_head_daily.sql
00170_topics_overview_rollup_reads.sql
00171_page_visibility_window.sql
00172_ai_traffic_visits.sql
00173_traffic_reads_count_visits.sql
00174_traffic_google_totals.sql
00175_ai_source_list.sql
00176_ai_traffic_merged.sql
00177_traffic_platform_value.sql
00178_ai_traffic_pages.sql
00179_ai_traffic_conversions.sql
00180_ai_traffic_google_trend.sql
00181_gsc_page_stats.sql
00182_ai_traffic_google_queries.sql
00183_ai_bot_events.sql
00184_ai_bot_raw_records.sql
00185_ai_bot_report.sql
00186_ai_traffic_broken_links.sql
00187_ai_traffic_digest.sql
00188_organization_ai_keys.sql
00189_ai_bot_ingest_file.sql
00190_ai_bot_report_coverage.sql
00191_same_mentions_kpis.sql
00192_rollup_integrity.sql
00193_ai_traffic_platforms_seen.sql
00194_ai_traffic_known_pages.sql
00195_mentions_same_prompt_changes.sql
00196_getting_started.sql
00197_getting_started_start_skip.sql
00198_webhook_event_subscriptions.sql
00199_serialize_citation_refreshes.sql
00200_ai_traffic_soft_404.sql
00201_gsc_pages_backfill_from.sql
00202_getting_started_steps_update_using.sql
00203_citation_gap_rollups.sql
00204_content_drafts.sql
00205_content_page_types.sql
00206_content_draft_start.sql
00207_content_page_overlap.sql
00208_content_draft_action.sql
00209_content_page_impact.sql
00210_content_page_results.sql
00211_content_draft_sources.sql
00212_content_draft_brief.sql
00213_content_draft_rules.sql
00214_content_rule_sets.sql
00215_content_draft_versions.sql
00216_content_draft_cited_answers.sql
00217_content_draft_suggestions.sql
00218_content_draft_action_work.sql
00219_content_draft_agent_state.sql
00220_content_plan_pages.sql
00221_content_plan_insights.sql
00222_cancellation_feedback.sql
00223_mention_sentiment_override_api.sql
00224_results_autovacuum.sql
00225_shopping_merchant_classification.sql
00226_content_reads_bounded.sql
00227_content_rule_sets_site_type.sql
00228_profiles_server_columns.sql
00229_content_plan_marks.sql
00230_content_start_prompts.sql
00231_mentions_perception_rollups.sql
00232_prompt_results_metrics_cover.sql
00233_content_drafts_archive.sql
00234_getting_started_plan_steps.sql
00235_service_write_policies_role.sql
00236_topics_overview_speed.sql
00237_mentions_perception_read_rollups.sql
00238_content_plan_pages_no_overlaps.sql
00239_mentions_list_index_only.sql
00240_content_draft_suggestion_links.sql
00241_mentions_perception_snapshots.sql
00242_ai_usage_by_feature.sql
00243_ai_usage_reservation.sql
00244_action_entities.sql
00245_action_count_drift.sql
00246_perception_snapshots_follow_rollups.sql
00247_content_page_suggestions.sql
00248_content_suggestion_sources.sql
00249_content_agent_runs.sql
00250_traffic_anonymous_visitors.sql
00251_chatgpt_shopping_visits.sql
00256_content_authors.sql
00257_content_draft_author.sql
00258_content_link_checks.sql
00259_site_trust.sql
00260_content_draft_ready_log.sql
00261_brand_content_byline.sql
00262_content_draft_deliveries.sql
00263_content_draft_kept_sources.sql
00264_content_source_classes.sql
00265_content_draft_inputs.sql
00266_content_quality_claims.sql
00267_shopping_overview_chatgpt_market.sql
00268_shopping_merchant_split.sql
00269_brand_facts.sql
00270_content_quality_pages.sql
00271_content_draft_author_confirmed.sql
00272_content_images_storage.sql
00273_content_draft_reviewer.sql
00274_content_quality_page_checks.sql
00275_content_quality_handoff.sql
00276_organization_insert_columns.sql
00277_brand_openai_product_feed.sql
00278_catalog.sql
00279_catalog_sources.sql
00280_content_draft_confirmations.sql
00281_catalog_variants_brand_live.sql
00282_catalog_store_connections.sql
00283_brand_cms_connections.sql
00284_content_delivery_targets.sql
00285_content_page_rewrite_reach.sql
00286_ai_traffic_conversions.sql
00287_content_page_conversions.sql
00288_brand_ai_conversions.sql
00289_content_draft_restored_at.sql
00290_mentions_perception_live_narrower.sql
00291_content_plan_pages_conversions.sql
00293_action_task_reviews.sql
00294_cms_wordpress.sql
00295_cms_framer.sql
00296_catalog_item_issues.sql
00350_catalog_category_pages.sql
00351_content_draft_shopping_path.sql
00352_content_shopping_checks.sql
00360_shopping_card_catalog_match.sql
00361_catalog_product_ai_stats.sql
00362_prompt_suggestions_catalog_source.sql
00363_prompt_table_views.sql
00364_cloro_countries.sql
00365_action_outcome_mixed.sql
00366_action_dismiss_reason.sql
00367_content_suggestion_decisions.sql
00368_action_scorecard.sql
00369_cited_page_features.sql
00370_prompt_demand.sql
00371_catalog_suggestion_categories.sql
00372_cms_wix.sql
00373_basket_positive_sentiment.sql
00374_menu_access.sql
00375_task_review_approve_api.sql
00376_competitor_page_timeline.sql
00377_gsc_shopping_appearance.sql
00378_cloro_pending_tasks_legacy.sql
00379_brand_site_type_source.sql
00380_demo_brand.sql
00381_demo_brand_writes.sql
00382_topics_manager_writes.sql
00400_chat_core.sql
00401_chat_settings.sql
00402_chat_activity.sql
00403_chat_access_requests.sql
00404_chat_model_prices.sql
00405_chat_ai_budget.sql
00406_chat_engine.sql