Alembic migration tool

Not currently set up; migrations are applied manually via SQL files. A plan to implement automated auto-migration on startup is recommended to prevent deployment issues, especially for agent-related tables.