Automation & Sync

ESI authentication, pipeline toggles, scheduler controls, and manual run operations.

Incremental database updates enabled Change in Automation Control

Data freshness summary

Keep the visible view centered on datasets, last successful refreshes, freshness, and only the latest failures.

Show advanced diagnostics

Market hub local history

market_hub_local_history

Stale

Last successful run

Never

Unavailable

Activity priority summary

activity_priority

Updating

Last successful run

2d ago

2026-04-01 13:20:05 UTC

Dashboard summary

dashboard_summary

Updating

Last successful run

5m ago

2026-04-03 17:33:41 UTC

Doctrine intelligence

doctrine_intelligence

Updating

Last successful run

5m ago

2026-04-03 17:33:42 UTC

Loss demand summary

loss_demand

Updating

Last successful run

2d ago

2026-04-01 13:19:57 UTC

Market comparison summary

market_comparison

Updating

Last successful run

6m ago

2026-04-03 17:32:54 UTC

Alliance market orders

alliance_market_orders

Fresh

Last successful run

5m ago

2026-04-03 17:33:41 UTC

Buy all planner

buy_all

Fresh

Last successful run

6m ago

2026-04-03 17:32:58 UTC

Deal alerts

deal_alerts

Fresh

Last successful run

6m ago

2026-04-03 17:32:52 UTC

Graph insights

graph_insights

Fresh

Last successful run

6m ago

2026-04-03 17:33:02 UTC

Graph sync

graph_sync

Fresh

Last successful run

5m ago

2026-04-03 17:34:20 UTC

Killmail stream

killmail_stream

Fresh

Last successful run

3m ago

2026-04-03 17:35:57 UTC

Reference hub orders

market_hub_orders

Fresh

Last successful run

5m ago

2026-04-03 17:34:15 UTC

Database migrations

SQL schema changes are auto-applied on page load. New or updated files in database/migrations/ are detected and run automatically.

Up to date
Show all 57 migration(s)

applied 20260325_counterintel_pipeline.sql 2026-03-30 16:34:16

applied 20260325_graph_schema_and_schedule_alignment.sql 2026-03-27 12:17:01

applied 20260325_graph_validation_queries.sql 2026-03-27 12:17:01

applied 20260326_add_engagement_avoidance_score.sql 2026-03-27 13:03:15

applied 20260326_create_buy_all_tables.sql 2026-03-27 12:17:01

applied 20260326_create_missing_analytics_tables.sql 2026-03-27 12:17:01

applied 20260326_enhanced_intelligence_platform.sql 2026-03-27 14:49:34

applied 20260326_fix_counterintel_features_columns.sql 2026-03-27 12:17:01

applied 20260326_intelligence_platform.sql 2026-03-27 13:03:15

applied 20260326_schema_migrations_bootstrap.sql 2026-03-27 12:17:01

applied 20260327_enhanced_intelligence_platform.sql 2026-03-27 13:03:15

applied 20260327_theater_ai_summary.sql 2026-03-27 18:55:09

applied 20260327_theater_intelligence.sql 2026-03-27 14:49:34

applied 20260328_fix_counterintel_missing_schema.sql 2026-03-28 02:17:45

applied 20260329_add_fleet_function_column.sql 2026-03-28 02:51:50

applied 20260329_esi_gateway_audit_tables.sql 2026-03-29 19:14:26

applied 20260329_fix_query_presets_use_populated_tables.sql 2026-03-28 00:37:14

applied 20260329_reconcile_intelligence_platform_schema.sql 2026-03-28 00:15:30

applied 20260329_theater_lock.sql 2026-03-29 12:26:34

applied 20260330_character_cohort_tables.sql 2026-03-30 16:34:16

applied 20260330_copresence_edges.sql 2026-03-30 20:49:10

applied 20260330_create_character_feature_histograms.sql 2026-03-31 02:01:56

applied 20260330_evewho_enrichment_queue.sql 2026-03-30 01:02:36

applied 20260330_evewho_enrichment_schedule.sql 2026-03-30 01:45:28

applied 20260330_item_criticality_index.sql 2026-03-28 04:52:05

applied 20260330_theater_side_composition.sql 2026-03-28 03:54:18

applied 20260331_add_last_run_summary_to_scheduler_job_current_status.sql 2026-03-31 16:34:22

applied 20260331_economic_warfare.sql 2026-03-28 09:18:22

applied 20260331_fix_compute_signals_snapshot_index.sql 2026-03-31 12:47:00

applied 20260331_npc_station_name_construction.sql 2026-03-31 13:55:12

applied 20260401_theater_participant_isk_lost.sql 2026-03-28 13:52:44

applied 20260401_tracked_alliance_member_sync_schedule.sql 2026-04-01 06:50:49

applied 20260401_universe_graph_stargates.sql 2026-03-28 18:02:17

applied 20260402_alliance_relationship_graph.sql 2026-04-02 04:10:22

applied 20260402_killmail_ingest_all.sql 2026-04-02 04:10:22

applied 20260402_theater_participant_ships_lost_detail.sql 2026-03-28 20:18:39

applied 20260403_corp_contacts_source.sql 2026-04-03 11:32:10

applied 20260403_corp_standings.sql 2026-04-03 08:17:36

applied 20260403_entity_metadata_resolve_sync.sql 2026-03-29 09:35:58

applied 20260403_intelligence_expansion.sql 2026-03-29 00:35:56

applied 20260403_page_cache.sql 2026-03-28 22:04:39

applied 20260403_theater_participant_flying_ship.sql 2026-03-29 09:20:08

applied 20260404_dag_aware_scheduling.sql 2026-03-30 04:46:07

applied 20260404_theater_snapshot.sql 2026-03-29 12:59:26

applied 20260405_evewho_alliance_member_sync_schedule.sql 2026-03-30 17:56:46

applied 20260405_full_history_backfill.sql 2026-03-30 07:45:22

applied 20260405_opponent_source_column.sql 2026-03-30 12:54:49

applied 20260405_standardize_signal_output.sql 2026-03-30 16:34:16

applied 20260406_character_movement_footprints.sql 2026-03-30 20:49:10

applied 20260407_killmail_overview_perf.sql 2026-03-31 11:36:35

applied 20260408_theater_structure_kills.sql 2026-03-31 12:23:41

applied 20260409_intelligence_missing_features.sql 2026-04-01 08:32:44

applied 20260409_jump_bridges.sql 2026-04-01 08:32:44

applied 20260409_theater_alliance_summary_corporation.sql 2026-04-01 07:23:20

applied 20260410_item_criticality_consumption_columns.sql 2026-04-02 05:03:53

applied 20260411_alliance_dossiers_killmail_based.sql 2026-04-02 10:57:56

applied 20260411_theater_participant_battle_stats.sql 2026-04-03 14:26:24

Backfill start is automatic. Pipelines begin from the date sync automation was enabled: 2026-04-03.

Market history retention tiers

The tiered model keeps raw capture tables short-lived, hourly rollups for the medium troubleshooting window, and daily history projections for the long-lived UI/reporting window.

Redis performance layer

Redis stays optional and non-authoritative. MySQL remains the source of truth while Redis accelerates cached summaries, comparison defaults, metadata lookups, and lightweight distributed locks.

Pipeline toggles

Pipeline runtime flags are managed centrally from Automation Control.

Automation Control →
Alliance current pipeline On
Alliance history/backfill pipeline On
Market hub history pipeline On
Hub snapshot-history refresh pipeline On

Static Data Source: https://developers.eveonline.com/static-data/eve-online-static-data-latest-jsonl.zip

Remote Build: 3284752

Imported Build: 3284752

Last Status: success (full)

When enabled, future import/sync jobs will only process changed rows for better scalability.

Local History is available in this selector and is required to populate Trend Snippets.

Clears stuck schedule locks and resets the scheduler daemon state. Use when jobs appear stuck or locks are not releasing.