ApiGen.Cli 1.0.0

🚀 api_gen - Enterprise .NET Web API Code Generation & Architecture Engine

Automated C# .NET 8/9 Web API Scaffolding Engine from SQL Server & PostgreSQL with AI DB Engineer, Persistent Architecture Memory, and Interactive Lazy Terminal UI.

🌟 1. Core System Features

• ⚡ CRUD & Customized API Generator:
  • Automatically scaffolds full RESTful CRUD APIs from database tables (Paging, Sorting, Filtering, Bulk Operations, Soft Delete).
  • Flexibly maps Stored Procedures (multiple Result Sets, IN/OUT parameters), Table-Valued Functions, Scalar Functions, and Database Views into specialized RESTful API endpoints.
• 🧠 AI DB Engineer & Persistent Architecture Memory (api_gen db-engineer):
  • Built-in AI Database Architect that connects to SQL Server / PostgreSQL, designs schema migrations (DDL), optimizes indexes, and maintains persistent database architecture memory (.api_gen/db_memory.json).
  • Automatically recalls past schema context across project iterations without re-scanning the database from scratch.
• 🖥 Interactive Lazy Terminal UI (api_gen lazy):
  • Keyboard-driven Terminal User Interface (TUI) inspired by Lazygit.
  • Toggle schema objects with [Space], preview live syntax-highlighted C# code in real-time, and trigger generation with [g].
• 🤖 End-to-End System Scaffolding (api_gen scaffold):
  • Type a high-level system prompt (e.g., api_gen scaffold "Learning Management System LMS"), and the engine automatically designs tables, foreign keys, views, stored procedures, and scaffolds the complete .NET solution in seconds.
• 🔐 Session Management & Enterprise Services:
  • Encrypted Local CLI Session state and runtime Output Application Session Provider (ICurrentUserSession, Redis/Memory Session, Auto-Audit & Procedure Parameter Binding).
  • Built-in integrations for MinIO / AWS S3 / Azure Blob Storage, Hangfire Background Jobs, MassTransit Event Bus (RabbitMQ), Rate Limiting Middleware, and Multi-Tenancy.
• 📦 Packaging & Export Engine:
  • Distributed as a standard Global .NET Tool (dotnet tool install -g api_gen) via NuGet Feed.
  • Automatically exports TypeScript Client SDK (api_client.ts) and Postman Collection (postman_collection.json).

💻 2. CLI Command Reference

🏗 3. Target Output Solution Architecture (.NET Clean Architecture)

The output C# solution strictly adheres to Clean Architecture & CQRS Pattern:

MySolution/
├── src/
│   ├── MyApi.Domain/                 # Entities, Value Objects, BaseEntity Audit
│   │   ├── Entities/
│   │   └── Common/
│   │
│   ├── MyApi.Application/            # DTOs, Interfaces, Validators, Feature Handlers
│   │   └── Features/
│   │       ├── Customers/
│   │       └── CustomProcedures/     # DTOs for Stored Procedures
│   │
│   ├── MyApi.Infrastructure/        # EF Core DbContext, Dapper Repositories, Redis, MinIO
│   │   ├── Data/
│   │   │   └── ApplicationDbContext.cs
│   │   └── Repositories/
│   │
│   └── MyApi.WebApi/                # Controllers, Program.cs, Swagger Docs, Middleware
│       └── Controllers/
│
└── api_gen.config.json               # Configuration Schema

🎛 4. Configuration Schema (api_gen.config.json)

{
  "ProjectSettings": {
    "SolutionName": "Avatech.SalesService",
    "Namespace": "Avatech.SalesService",
    "TargetDotNetVersion": "net8.0",
    "Architecture": "CleanArchitecture",
    "OrmType": "Hybrid"
  },
  "Database": {
    "Provider": "SqlServer",
    "ConnectionString": "Server=localhost;Database=SalesDb;User Id=sa;Password=YourPassword123;TrustServerCertificate=True;"
  },
  "GeneratorOptions": {
    "GenerateCrudControllers": true,
    "GenerateSwaggerDocs": true,
    "EnableSoftDelete": true,
    "SoftDeleteColumn": "IsDeleted",
    "AuditColumns": ["CreatedBy", "CreatedAt", "UpdatedBy", "UpdatedAt"]
  }
}

🚀 5. Installation & Global .NET Tool Usage

# 1. Build and pack into NuGet Tool Package
dotnet pack src/ApiGen.Cli/ApiGen.Cli.csproj -c Release -o ./nupkg

# 2. Install as a Global .NET Tool
dotnet tool install -g --add-source ./nupkg ApiGen.Cli

# 3. Execute anywhere on your system
api_gen init
api_gen generate