Agent skill
CA Lobby BigQuery Integration
BigQuery integration patterns for CA Lobby lobby data with BLN API schema. Use when working with CA Lobby backend, database queries, or data service. Provides CA-specific BigQuery patterns and Flask integration guidance.
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/testing/ca-lobby-bigquery-integration-ingramml-ca-lobby-prod-test
SKILL.md
CA Lobby BigQuery Integration
CA Lobby Configuration
Database Type: BigQuery
Backend Location: webapp/backend/
Data Service: webapp/backend/data_service.py
Schema Source: Big Local News (BLN) API
ORM: SQLAlchemy
CA Lobby BigQuery Specifics
Key Files
webapp/backend/app.py- Flask applicationwebapp/backend/data_service.py- Data access layerwebapp/backend/database.py- Database connections
BLN API Schema
- Organizations
- Lobbyists
- Lobbying Activities
- Expenditures
- Payments
Demo Mode
IMPORTANT: Project has demo mode flag
REACT_APP_USE_BACKEND_API=true- Use backendREACT_APP_USE_BACKEND_API=false- Use demo data (default)
Common Query Patterns
- Organization search
- Expenditure aggregations
- Lobbyist network queries
- Date-range filtering
- Activity timelines
Changelog
Version 1.0.0 (2025-10-20)
- Initial CA Lobby implementation
- BigQuery specific patterns
- BLN API schema integration
End of Skill
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?