Getting Started

Welcome to Beacon! Beacon is a .NET 9 platform for semantic database monitoring, alerting, ETL / data migration, and cross-database queries, with an AI layer and a built-in MCP server. This section gets you from zero to your first scheduled database alert.

How Beacon Is Delivered

Beacon ships two ways, and you can use either:

  1. As a self-hostable application — clone the repository and run the Beacon.SampleProject host (the composition root). It boots Kestrel, serves the React single-page app at the root URL, exposes the REST API, MCP server, and SignalR hub, and applies database migrations on first run.
  2. As NuGet packages — embed Beacon into your own ASP.NET Core application by referencing the Beacon.* packages and wiring them in Program.cs.

The Installation guide covers both paths in detail.

What You’ll Learn

  • Installation — Run the host or embed Beacon into your own ASP.NET Core app
  • Quick Start — Create your first data source, query, subscription, and notification
  • Configuration — Connection strings, encryption key, auth, AI/LLM, and scheduling

Prerequisites

Before you begin, ensure you have:

  • .NET 9.0 SDK or later
  • PostgreSQL 12+ or SQL Server 2019+ for Beacon’s metadata database
  • Node.js 18+ and npm (only if you build or run the React frontend from source)
  • An encryption key (Beacon:EncryptionKey) — required; generate with openssl rand -base64 32
  • Basic SQL knowledge

Architecture at a Glance

flowchart TB
    Browser["Browser<br/>React SPA (Vite + Tailwind v3.4)"]
    MCPClient["MCP Client<br/>(Claude, IDE, agents)"]

    subgraph Host["Beacon.SampleProject (Kestrel host)"]
        UI["Beacon.UI<br/>Razor Class Library<br/>serves SPA at /"]
        API["REST API<br/>/beacon/api/* (Minimal APIs)"]
        Hub["SignalR Hub<br/>/beacon/api/hub"]
        MCP["MCP Server<br/>/beacon/mcp (Streamable HTTP)"]
    end

    subgraph Core["Beacon.Core + Beacon.AI + Beacon.MCP"]
        Mediatr["MediatR / CQRS handlers"]
        AI["AI layer<br/>(runtime-swappable LLM + queue)"]
        Scheduler["IBeaconScheduler<br/>(pluggable scheduler)"]
    end

    subgraph Data["Data layer"]
        Meta[("Metadata DB<br/>PostgreSQL / SQL Server<br/>EF Core 9, schema 'beacon'")]
        Sources[("Monitored data sources<br/>9 connectors")]
    end

    Browser -->|"HTTP + WebSocket"| API
    Browser --> UI
    API --> Hub
    MCPClient -->|"auth required"| MCP
    API --> Mediatr
    MCP --> Mediatr
    Mediatr --> AI
    Mediatr --> Scheduler
    Mediatr --> Meta
    Scheduler --> Meta
    Mediatr --> Sources

Quick Overview

Beacon enables you to:

  1. Connect to your data sources — PostgreSQL, SQL Server, MySQL, Google BigQuery, Snowflake, Databricks, Azure Synapse, AWS CloudWatch, and generic REST APIs (9 connectors)
  2. Define SQL queries (including cross-database queries) to monitor your data
  3. Schedule execution with cron expressions via the pluggable scheduler
  4. Deliver results via Email, Microsoft Teams, or Jira
  5. Migrate data between databases with ETL pipelines
  6. Integrate with AI agents through the built-in MCP server

Let’s get started!

Next Steps

📦 Installation Guide →

Run the host or embed Beacon into your ASP.NET Core app

🚀 Quick Start →

Create your first data source, query, and notification

⚙️ Configuration →

Connection strings, encryption, auth, AI/LLM, and scheduling


Table of contents