Schmr
SQL Server schema tooling for .NET teams

Turn tangled SQL Server schemas into clean visuals and usable code.

Schmr helps .NET developers explore legacy databases, generate DTOs, build Dapper queries visually, preview results, and save the workflows they actually reuse.

Open the appSee how it works

For .NET developers working through legacy SQL Server schemas, Dapper-heavy services, and internal tools.

Schema graph

Tables, keys, joins

Code output

DTOs, SQL, Dapper

Daily use

Saved layouts and queries

Live workflow

Schema to code, without bouncing between tools

Preview-ready

Orders

Sales.Orders

Base
Idint
Namenvarchar
Statustinyint

Customers

Sales.Customers

Join
Idint
Namenvarchar
Statustinyint

Invoices

Billing.Invoices

Join
Idint
Namenvarchar
Statustinyint

Generated query

SELECT
    o.OrderId,
    o.OrderDate,
    c.Name AS CustomerName
FROM Sales.Orders o
INNER JOIN Sales.Customers c
    ON c.CustomerId = o.CustomerId

DTO output

public sealed record OrderSummaryDto(
    int OrderId,
    DateTime OrderDate,
    string CustomerName
);

Why it matters

Stop stitching together SSMS tabs, handwritten DTOs, and one-off SQL files.

Old workflow

  • Dig through SSMS to understand joins.
  • Manually map tables into DTOs.
  • Hand-build Dapper queries from scratch.
  • Run a query somewhere else just to validate it.

Schmr workflow

  • Connect to the database once.
  • See structure and relationships visually.
  • Select tables and columns for the query you need.
  • Preview results, then copy code with confidence.

Features

Everything you need to move from schema exploration to working code.

Visual schema explorer

Connect to SQL Server and inspect tables, columns, and foreign keys in a clean interactive graph.

DTO generation

Click a table and generate usable C# DTOs without hand-mapping every property.

Dapper query builder

Choose tables and columns visually, then let Schmr assemble SQL and the Dapper method.

Query preview

Inspect sample rows before copying anything into a production project.

Saved workflows

Keep useful queries, layouts, and graph arrangements around for real daily use.

Connection profiles

Save reusable SQL Server connections so repeat work starts faster.

Workflow

A fast path from database context to generated output.

1

Connect to your SQL Server database

2

Explore tables and relationships visually

3

Select tables and columns for the query you need

4

Preview results and generate SQL, DTOs, and Dapper code

Built for developers

Schmr is for teams that work with SQL Server every day, not for generic BI workflows.

If your day involves Dapper, legacy schemas, unfamiliar joins, or internal tools built on existing databases, Schmr gives you a faster way to understand structure and produce usable code.

.NET developers using Dapper in real projects
Teams working with large or legacy SQL Server schemas
Consultants auditing unfamiliar client databases
Engineers building internal tools on top of existing data models

Pricing

Start with the core workflow, then grow into the features you keep using.

Starter

Free

A practical entry point for developers exploring schemas and generating code.

  • • Visual schema explorer
  • • DTO generation
  • • Basic query building
  • • Local workflow preview

Pro

$19/month

For teams who want previews, persistence, and a faster path through real SQL Server work.

  • • Query preview
  • • Saved queries and layouts
  • • Connection profiles
  • • Priority feedback

Updates

Use Schmr now, and subscribe if you want release notes as it keeps evolving.

The app is already usable. If you want product updates, release notes, and new feature announcements, leave your email here and I'll send the important ones.

No spam. Just product updates and release notes.

Schmr

Stop hand-writing schema glue code.

Explore the schema, preview the query, generate the code, and keep the useful pieces around for the next time.

Open the appGet product updates