ci(hooks): add pre-commit config with ruff and mypy hooks

test(database): add integration test for CSV column validation

refactor(database): decouple Streamlit caching from connection module

fix: restore player search functionality and add HF frontmatter

Address reviewer feedback: fix grammar, path resolution, and sampling logic

Transition data layer to local CSV using pandas

Fix CI failures: type annotations, linting, and coverage threshold

Refactor app with security fixes, error handling, and type safety