O
OmniStack
ComponentsDocsPricing
YouTubeLinkedInWebsiteGitHubGet Started
IntroductionQuick StartInstallation
AuthenticationPaymentsUI ComponentsMediaFormsE-Commerce
Next.jsExpoGo
Back

GORM Studio

A Prisma Studio-like visual database browser and editor for Go applications using GORM. Browse schemas, manage data with full CRUD, run SQL queries, export ERD diagrams (PNG/PDF), import/export data in multiple formats (JSON, CSV, SQL, Excel, DBML, YAML), and generate Go model code — all from a single studio.Mount() call embedded in your Gin application.

GoDatabase
View Full Documentation

What's Included

Visual Schema Browser
Full CRUD Data Management
Raw SQL Editor (DDL-Safe)
ERD Diagram Export (PNG & PDF)
Data Export (JSON, CSV, SQL)
Data Import (JSON, CSV, SQL, Excel)
Go Model Code Generation
Schema Import (SQL, DBML, YAML)
Relationship Navigation
Bulk Operations
Auth Middleware Support
SQLite, PostgreSQL & MySQL

Installation

terminal
$ go get github.com/MUKE-coder/gorm-studio/studio

How to Use

1

Install the package

Add GORM Studio to your Go project alongside Gin and GORM.

go get github.com/MUKE-coder/gorm-studio/studio
2

Mount in your Gin app

Pass your GORM database instance and model list to studio.Mount(). That's it — one line.

import (
    "github.com/MUKE-coder/gorm-studio/studio"
    "github.com/gin-gonic/gin"
    "gorm.io/gorm"
)

router := gin.Default()
studio.Mount(router, db, []interface{}{&User{}, &Post{}})
router.Run(":8080")
3

Open the studio

Navigate to /studio in your browser to browse schemas, manage data, run SQL, and export diagrams.

# Open http://localhost:8080/studio
4

Configure for production

Add authentication, read-only mode, or disable the SQL editor for production environments.

studio.Mount(router, db, models, studio.Config{
    Prefix:         "/admin/studio",
    ReadOnly:       true,
    DisableSQL:     true,
    AuthMiddleware: gin.BasicAuth(gin.Accounts{
        "admin": "secret-password",
    }),
})
Free
Open source component

Free to use · MIT License

CategoryDatabase
PlatformsGo
Features12
Resources
Component DocsOmniStack Docs