skills.rest
Mord0reK
Mord0reKCOMMUNITY
Explore all skills by this author →
GitHub

panel-backend-go

Configure a Go backend API with SQLite, goose migrations, SSE, and JWT auth.

Updated Aug 27, 2026
Search Tags:#migrations#jwt#backend#go#sqlite#sse#gorilla-mux
One-click install
npx skills add https://github.com/Mord0reK/panel --skill panel-backend-go
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: panel-backend-go
Source: https://github.com/Mord0reK/panel/tree/main/.claude/skills/panel-backend-go
Command: npx skills add https://github.com/Mord0reK/panel --skill panel-backend-go

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill standardizes the setup of a Go-based backend API with SQLite storage, embedded migrations via goose, Server-Sent Events (SSE) streaming, and JWT-based authentication, reducing boilerplate and promoting production-ready patterns.

Core Features & Use Cases

  • SQLite integration using database/sql and modernc for a CGO-free, single-writer pattern.
  • Embedded migrations with goose to manage schema changes across deployments.
  • SSE and routing using gorilla/mux and SSE signals for live metrics and status updates.
  • JWT authorization with HS256 tokens and middleware for protected API endpoints.
  • Module map & architecture guidance for building scalable Go backend services.

Quick Start

Start the backend by running the main server entrypoint to boot the API with SQLite, migrations, SSE, and JWT auth.

Frequently Asked Questions about panel-backend-go

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I set up a Go backend API with SQLite and JWT authentication?▼

You can set up a Go backend API with SQLite and JWT by using database/sql with modernc for CGO-free storage, gorilla/mux for routing, goose for embedded migrations, and HS256 JWT middleware for protected endpoints.

What is the single-writer SQLite pattern in Go and when do I need it?▼

The single-writer SQLite pattern restricts write operations to one connection to prevent database lock contention, enforced when building persistent Go backend APIs using modernc.org/sqlite.

Can I use Server-Sent Events with Gorilla Mux for live metrics in a Go API?▼

Yes, Server-Sent Events work with Gorilla Mux to stream live metrics and status updates in a Go API by utilizing SSE signals for real-time data delivery to connected clients.

Does this Go backend configuration require CGO for SQLite integration?▼

No, CGO is not required for SQLite integration because the configuration uses modernc.org/sqlite, providing a pure Go driver operating within the database/sql interface without C dependencies.

How do I manage database schema changes with embedded migrations in a Go backend?▼

You manage schema changes in a Go backend by embedding migration files with goose, which handles schema versioning and deployment tracking across SQLite database instances automatically.

What are the limitations of using SQLite for microservices in Go?▼

SQLite limitations for Go microservices include the single-writer constraint restricting concurrent write throughput, making it suitable for specific persistent storage and live metrics scenarios rather than high-volume write environments.

Related Skills

Explore More Software Engineering Skills→
PaulRBergPaulRBerg

new-terraform-provider

Scaffold a Terraform provider workspace and bootstrap a Go module.

Community
Intermediate
freedomw1987freedomw1987
2

nginx-sse-streaming-fix

Configure nginx and backend headers to disable buffering for SSE streaming.

Community
Intermediate
uneezaismailuneezaismail

better-auth

Integrate Better Auth shared-secret JWT authentication between Next.js and FastAPI.

Community
Advanced
modu-aimodu-ai
1.2k

moai-lang-go

Develops Go microservices and CLI tools with Fiber, Gin, GORM, and concurrency.

Official
Intermediate