Your DbContext. One desktop app.

MyEFvibe Studio

A LINQPad-style scratchpad for Entity Framework Core — without leaving your solution’s build graph. Studio runs the same efvibe serve engine as the CLI and editor extensions, but wraps it in a dedicated workspace: multiple connections, query tabs, notebooks, ER diagrams, scan review, and team query packs.

Tauri 2 + React + Monaco Linux · Windows · macOS arm64 .NET 8+ · efvibe on PATH Apache 2.0
Studio query view — editor, results, and live SQL pane
Studio query view — editor, results, and live SQL pane

Who is Studio for?

Teams that live in EF Core and need a fast, honest answer to “what SQL does this LINQ run?” — without spinning up the full API, tailing logs, or juggling three tools.

  • Backend / full-stack developers Prototype LINQ against real entities, includes, and filters before committing repository code.
  • Tech leads and reviewers Reproduce a suspicious query from a PR, inspect SQL and plans, and share a saved .efvibe-query with context.
  • Performance-minded engineers Run lite/deep LINQ scans, review findings in-app, and jump to source in VS Code, Rider, or Visual Studio.
  • Teams with multiple databases One .efvibe-workspace file — AdventureWorks on SQL Server, Pagila on PostgreSQL, side by side.

Why Studio instead of only the CLI or an IDE extension?

The CLI and VS Code / Rider extensions are excellent when you already live in a terminal or editor session. Studio is for when you want a persistent lab bench dedicated to data access work.

  • Multi-connection workspaces Save EF projects, startup apps, script helpers, and connection strings (optionally vaulted) in one file.
  • Query tabs + notebooks + REPL Three exploration modes in one app — not scattered across terminal tabs and editor panels.
  • Team packs and sync Export favorite queries and snippets; push/pull via a shared folder or cloud sync directory.
  • Same engine, richer shell Charts, history, benchmarks, ER diagrams, and script editing — orchestration on top of proven efvibe serve.

Use cases

Concrete workflows Studio is built around.

Explore a new schema

Open the ER diagram, browse DbSets in the explorer, run Count and Sample actions, then write LINQ with autocomplete from your real model.

Debug a slow endpoint

Paste repository LINQ into a query tab, run with plan, compare timings in Charts, tweak filters, and save the fixed expression as a favorite.

Shared query library

Star tabs, organize folders, export a team pack, and push favorites to a Dropbox or git-backed sync folder — without sharing connection secrets.

Reusable script helpers

Keep .csx filters and constants beside your workspace; edit them in the Scripts panel with syntax highlighting and auto-load on connection refresh.

Investigate with raw SQL

Paste SELECT from SSMS or pgAdmin when you need to probe the database directly; switch back to LINQ when you know the shape.

Notebook walkthroughs

Document an investigation in markdown cells, run code cells in order, and save .efvibe-notebook files for onboarding or incident postmortems.

Feature overview

Everything in Studio routes through a long-lived efvibe serve daemon — fast re-runs, warm builds, stable JSON results.

Query workspace

Monaco editor

C# and SQL syntax highlighting, F5 Run all, Ctrl+Enter Run current line, optional lambda mode, and a debounced live SQL preview pane (ToQueryString() as you type).

Script attributes

#[Compare("label")] for multi-variant LINQ experiments and #[Benchmark(N)] for timed runs — results in the Result tab via Run all.

Three query styles

Fluent LINQ, query comprehension (from … in db.Set), and raw SQL — all against the same connection.

Results dock

Grid, object tree, compare table, or benchmark stats in Result; SQL, plan, messages; CSV/JSON export; optional save-back for tracked entities.

SQL ↔ LINQ

Paste SQL for a draft LINQ expression (daemon sqlToLinq); preview translated SQL before you run.

Query view — Result, SQL, Plan, and live LINQ → SQL preview

Connections & scripts

Connection manager

EF project, startup project, DbContext, framework, connection string override, and optional secret vault.

Script session

Preload .csx helpers, additional usings, inline #load, and a default scripts/ folder beside your workspace file.

Scripts panel

Browse, create, and edit script files from the left tool rail with C# highlighting; saves restart the daemon.

Schema explorer

DbSet tree with Query, Sample, Count, Describe, and ER diagram actions from context menus.

Script session settings and in-app script editor

Editor tools

History & Charts

Recent evaluations (7 days), timing breakdowns, benchmark bars, and compare-to-baseline when you set a baseline run.

Snippets & packs

Built-in EF snippets, custom snippets, marketplace packs, and install-from-URL for .efvibe-pack files.

Scan review

Lite and deep LINQ scans with carousel review, dismissals, notes, run-adapted-query, and open-in-IDE.

Favorites & library

Star query tabs, folder organization, and search across open tabs and saved queries.

Scan findings and session timing charts

Notebooks, diagrams & REPL

Notebook view

Code and markdown cells, run above/below, save as, inline outputs — saved as .efvibe-notebook.

ER diagram

Mermaid entity-relationship diagram for the active model; filter by entity from the explorer.

Embedded REPL

Full efvibe repl in a terminal pane, or open the same session in your system terminal.

Team & git

Export/import team packs, sync folders, cloud sync for favorites, and commit workspace/query/notebook files from the explorer.

Notebook cells and ER diagram view

Prerequisites & platforms

.NET
.NET SDK 8+

Studio builds your EF project through efvibe — same requirements as the CLI.

CLI
efvibe on PATH

dotnet tool install --global efvibe or configure a tool path in Settings.

OS
Linux x64, Windows x64, macOS Apple Silicon

Release builds: .deb, .rpm, .AppImage, .msi, .exe, macOS arm64 — see GitHub releases.