SqlOS 2.1.0

SqlOS

Embedded auth server and fine-grained authorization for .NET — one NuGet package, zero external services.

SqlOS gives your .NET app a complete auth stack — OAuth 2.0 endpoints, a branded login/signup UI, organization management, SAML SSO, OIDC social login, and hierarchical fine-grained authorization — all stored in your own SQL Server database, managed through an embedded admin dashboard.

Think WorkOS / AuthKit, but self-hosted and database-owned.

Why SqlOS?

Features

AuthServer

• OAuth 2.0 with PKCE — /authorize, /token, /.well-known/oauth-authorization-server, /.well-known/jwks.json
• Branded AuthPage — hosted /login, /signup, and /logged-out with customizable branding
• Organizations & Users — multi-tenant user management with memberships and roles
• Password Credentials — secure local authentication with session management
• Social Login — Google, Microsoft, Apple, and any custom OIDC provider
• SAML SSO — enterprise single sign-on with home realm discovery by email domain
• Sessions & Refresh Tokens — full lifecycle management with revocation
• Signing Key Rotation — automatic RS256 key rotation with configurable intervals
• Audit Logging — track authentication events across your system

FGA (Fine-Grained Authorization)

• Hierarchical Resource Authorization — define resource types, permissions, and roles
• Access Grants — assign permissions to users, user groups, and service accounts
• EF Core Query Filters — filter authorized resources directly in LINQ queries
• Access Tester — verify authorization decisions through the dashboard

Embedded Admin Dashboard

• Auth Admin — manage organizations, users, clients, OIDC/SAML connections, security settings, sessions, and audit events
• FGA Admin — manage resources, grants, roles, permissions, and test access decisions
• Password-Protected — optional password auth mode for production deployments

Quick Start

Install

dotnet add package SqlOS

Register Services

builder.Services.AddSqlOS<AppDbContext>(options =>
{
    options.UseFGA();
    options.UseAuthServer();
});

Configure Your DbContext

public sealed class AppDbContext : DbContext, ISqlOSAuthServerDbContext, ISqlOSFgaDbContext
{
    public IQueryable<SqlOSFgaAccessibleResource> IsResourceAccessible(
        string subjectId,
        string permissionKey)
        => FromExpression(() => IsResourceAccessible(subjectId, permissionKey));

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);
        modelBuilder.UseAuthServer();
        modelBuilder.UseFGA(GetType());
    }
}

Map Endpoints

var app = builder.Build();

await app.UseSqlOSAsync();
app.MapAuthServer("/sqlos/auth");
app.UseSqlOSDashboard("/sqlos");

That's it. SqlOS bootstraps its own schema, runs embedded migrations, and serves the dashboard — no external infrastructure required.

AuthServer-Only Mode

Already have an authorization layer? Use just the auth server:

builder.Services.AddSqlOSAuthServer<AppDbContext>(auth =>
{
    auth.BasePath = "/sqlos/auth";
    auth.PublicOrigin = "https://api.example.com";
    auth.Issuer = "https://api.example.com/sqlos/auth";
});

await app.UseSqlOSAuthServerAsync();
app.MapAuthServer("/sqlos/auth");
app.UseSqlOSAuthServerDashboard("/sqlos/admin/auth");

Dashboard Access

Protect the dashboard in production with a password:

options.Dashboard.AuthMode = SqlOSDashboardAuthMode.Password;
options.Dashboard.Password = builder.Configuration["SqlOS:Dashboard:Password"];

Or via environment variables:

SqlOS__Dashboard__AuthMode=Password
SqlOS__Dashboard__Password=<strong-password>

Example App

The repo includes a full working example powered by .NET Aspire:

dotnet run --project examples/SqlOS.Example.AppHost/SqlOS.Example.AppHost.csproj

This starts SQL Server, an ASP.NET API with SqlOS, and a Next.js frontend demonstrating password login, social OIDC, SAML SSO, session management, and FGA-protected data.

Requirements

• .NET 9.0+
• SQL Server (any edition, including LocalDB)
• EF Core 9.0+

Testing

# Unit tests
dotnet test tests/SqlOS.Tests/SqlOS.Tests.csproj

# Integration tests (requires SQL Server)
dotnet test tests/SqlOS.IntegrationTests/SqlOS.IntegrationTests.csproj

# Full suite
dotnet test SqlOS.sln

Repo Layout

src/SqlOS                                # The library
tests/SqlOS.Tests                        # Unit tests
tests/SqlOS.IntegrationTests             # Integration tests
tests/SqlOS.Benchmarks                   # Performance benchmarks
examples/SqlOS.Example.Api               # ASP.NET API example
examples/SqlOS.Example.Web               # Next.js frontend example
examples/SqlOS.Example.AppHost           # Aspire orchestration

Documentation

• Configuration — service registration, EF integration, dashboard setup
• Auth Page — hosted OAuth endpoints and branded UI
• OIDC Auth — OpenID Connect provider support
• Google OIDC · Microsoft OIDC · Apple OIDC · Custom OIDC
• Entra SSO Testing — SAML SSO with Microsoft Entra
• Example App — running the demo stack
• Testing — test structure and conventions
• Releasing — versioning and release process

License

MIT