Features
Reference guides for Beacon’s capabilities.
Core Features
Section titled “Core Features”Manage connections across nine connectors — PostgreSQL, SQL Server, MySQL, Google BigQuery, Snowflake, Databricks, Azure Synapse, AWS CloudWatch, and a generic REST API. Organize them into projects for your monitoring queries.
Define SQL queries with parameter support. Create simple queries or multi-step workflows.
Schedule query execution with cron expressions. Control when and how often your queries run.
Deliver query results via Email, Microsoft Teams, Slack, or Jira. Configure recipients and notification formats.
Extract, transform, and load data between databases using multi-step ETL pipelines. Supports cross-database migrations with scheduling and retry.
Connect AI assistants (Claude, Cursor, Windsurf, claude.ai, ChatGPT, VS Code) to your data through the Model Context Protocol. Eight tools covering natural-language questions, grounding context, SQL validation, direct queries, catalog search, documentation, and answer feedback — all project-scoped with API key authentication, AST read-only validation, and a self-improving learning loop.
What Beacon puts in front of the model before it writes SQL: M-Schema with real sample values, curated join paths, a business glossary, human-verified golden examples, mined learned patterns, and local semantic retrieval.
Operations & Quality
Section titled “Operations & Quality”A real-time operations view across every scheduled check: health buckets, success rates, anomaly sparklines, and open-task counts — auto-refreshing.
Alerting tasks created automatically when a check finds problems, tracked through to resolution and auto-resolved when the data recovers.
Define data contracts and evaluate them on a schedule, with scoring and evaluation history.
Advanced Features
Section titled “Advanced Features”Built-in user management with internal (password) and external (JWT/OAuth) authentication. First-run setup wizard, role assignment, and account administration.
Runtime application configuration through the Admin Settings UI. Hot-swap LLM providers, manage base URL, and view change history — all without restarting.
Flexible authorization for your Beacon installation. Supports role-based access control (RBAC), database-backed roles, and custom authorization providers, and integrates with any authentication system.
Statistical anomaly detection that learns baselines from historical execution data and alerts on unusual patterns.
Scoped API keys (Read, Execute, Admin) with optional per-project restrictions and expiry — SHA256-hashed at rest, shown exactly once.
Auto-generate data source documentation with ERD diagrams and turn natural language into SQL alerts using a runtime-swappable LLM provider.
LLM-driven monitoring agents whose plans pass through a human approval workflow before anything executes.
Quick Links
Section titled “Quick Links”New to Beacon? Start with the Quick Start Guide to create your first alert.
For advanced use, see Queries for multi-step query chaining and cross-database joins, and Data Sources for schema-agnostic, multi-tenant configuration.