NSGM CLI is a comprehensive full-stack development framework that combines the power of modern web technologies with intelligent code generation capabilities. It helps developers rapidly build scalable web applications through an interactive CLI wizard and automated code templates.

┌─────────────────┐    ┌─────────────────┐    ┌─────────────────┐
│   Frontend      │    │   Backend       │    │   Database      │
│   Next.js       │◄──►│   Express.js    │◄──►│   MySQL         │
│   React         │    │   GraphQL       │    │   Native SQL    │
│   Styled-Comp   │    │   REST API      │    │   Relations     │
└─────────────────┘    └─────────────────┘    └─────────────────┘

• Smart Mode Detection: Automatically switches between interactive and command-line modes
• Beginner-Friendly: Step-by-step guided setup for newcomers
• Expert-Efficient: Quick command-line shortcuts for experienced developers

• Code Generation: Automatic CRUD operations, API endpoints, and database schemas
• Hot Reload: Instant development feedback
• Type Safety: Full TypeScript support throughout the stack

• CSRF Protection: Built-in cross-site request forgery prevention
• Password Encryption: bcrypt-based secure authentication
• Session Management: Robust user session handling
• CSP Headers: Content Security Policy implementation

• Frontend: Next.js 13+, React 18+, Styled-components, Redux Toolkit
• Backend: Express.js, GraphQL, REST APIs
• Database: MySQL with native drivers
• DevTools: TypeScript, ESLint, Prettier, Jest

# Using npm
npm install -g nsgm-cli

# Using yarn
yarn global add nsgm-cli

# Using pnpm
pnpm add -g nsgm-cli

nsgm --version
# Should output: 2.1.13

# Start the interactive wizard (recommended for beginners)
nsgm init

# Or specify project name directly
nsgm init my-awesome-app

The wizard will guide you through:

• ✅ Project name and directory
• ✅ Database configuration
• ✅ Security settings
• ✅ Initial controller setup

cd your-project-name

# Copy environment template
cp .env.example .env

Default Login: admin/admin123

To change password (optional):

# Generate secure password hash
npm run generate-password yourNewPassword

# Edit .env file with generated hash
nano .env

# Install dependencies
npm install

# Start development server
npm run dev

Your application will be available at http://localhost:3000 with:

• 🎛️ Admin dashboard with CRUD interface
• 📊 Data import/export functionality
• 🗑️ Batch operations support
• 🔐 Secure login system (Default: admin/admin123)

# Database operations
nsgm deletedb user           # Delete controller + database table

# Project maintenance
nsgm upgrade                 # Upgrade project base files
nsgm export                  # Export static pages

# Development tools
npm run lint                 # Code linting
npm run test                 # Run tests
npm run test:coverage        # Test coverage report

Each controller created with nsgm create includes:

• GraphQL Schema: Typed queries and mutations
• GraphQL Resolvers: Business logic implementation
• REST API Endpoints: RESTful service layer
• Database Models: MySQL schema definitions
• Data Validation: Input sanitization and validation

• React Components: Modern functional components with hooks
• Styled Components: CSS-in-JS styling
• Redux Integration: State management
• Form Handling: Create, edit, and validation forms
• Data Tables: Sortable, filterable data grids

• Create: Add new records with validation
• Read: List, search, and pagination
• Update: Edit existing records
• Delete: Single and batch deletion
• Import/Export: CSV and JSON data handling

your-project/
├── client/                 # Frontend code
│   ├── components/         # React components
│   ├── layout/            # Layout components
│   ├── redux/             # State management
│   ├── service/           # API services
│   ├── styled/            # Styled components
│   └── utils/             # Utility functions
├── server/                # Backend code
│   ├── apis/              # REST API routes
│   ├── modules/           # GraphQL modules
│   ├── sql/               # Database scripts
│   └── utils/             # Server utilities
├── pages/                 # Next.js pages
├── public/                # Static assets
├── scripts/               # Build and deployment scripts
├── __tests__/             # Test files
├── .env.example           # Environment template
├── next.config.js         # Next.js configuration
├── mysql.config.js        # Database configuration
└── package.json           # Dependencies

# .env file
NODE_ENV=development
LOGIN_USERNAME=admin
LOGIN_PASSWORD_HASH=your_generated_hash  # Default: admin123
DATABASE_URL=mysql://user:password@localhost:3306/dbname

# Optional
PORT=3000
NEXT_PUBLIC_API_URL=http://localhost:3000

// mysql.config.js
module.exports = {
  mysqlOptions: {
    host: process.env.DB_HOST || 'localhost',
    port: process.env.DB_PORT || 3306,
    user: process.env.DB_USER || 'root',
    password: process.env.DB_PASSWORD || '',
    database: process.env.DB_NAME || 'nsgm_db',
  },
}

Default Login Credentials: admin/admin123

# Generate secure hash for custom password
npm run generate-password yourNewPassword

# Add to .env file
LOGIN_PASSWORD_HASH=your_generated_hash_here

NSGM CLI includes built-in CSRF protection:

// Automatic CSRF token generation
app.use(csrfProtection)

// Custom CSP headers
app.use(
  createCSPMiddleware({
    directives: {
      defaultSrc: ["'self'"],
      styleSrc: ["'self'", "'unsafe-inline'"],
      scriptSrc: ["'self'"],
    },
  })
)

# Run all tests
npm test

# Watch mode
npm run test:watch

# Coverage report
npm run test:coverage

# Lint code
npm run lint

# Format code
npm run format

# 1. Initialize project
nsgm init my-blog

# 2. Create controllers
cd my-blog
nsgm create post
nsgm create category
nsgm create user

# 3. Start development
npm run dev

// server/apis/custom.js
const express = require('express')
const router = express.Router()

router.get('/stats', (req, res) => {
  res.json({
    totalPosts: 42,
    totalUsers: 15,
    lastUpdate: new Date(),
  })
})

module.exports = router

// server/modules/blog/schema.js
module.exports = {
  query: `
    posts(limit: Int, offset: Int): [Post]
    post(id: ID!): Post
  `,
  mutation: `
    createPost(title: String!, content: String!): Post
    updatePost(id: ID!, title: String, content: String): Post
    deletePost(id: ID!): Boolean
  `,
  type: `
    type Post {
      id: ID!
      title: String!
      content: String!
      createdAt: Date!
      updatedAt: Date!
    }
  `,
}

# Production build
npm run build

# Analyze bundle size
npm run analyze

# Export static site
npm run export

# Start production server
npm start

# Or use PM2
pm2 start npm --name "nsgm-app" -- start

NSGM CLI 完全支持 Vercel 部署，包括自动化 CI/CD 流程。

快速开始：

1. 推送项目到 GitHub
2. 访问 Vercel Dashboard
3. 导入 GitHub 仓库
4. 配置环境变量（参考 .env.vercel.example）
5. 点击 "Deploy"

详细指南： 查看 VERCEL_DEPLOYMENT.md

特性：

• ✅ 自动 CI/CD 流程
• ✅ 预览环境（每个 PR）
• ✅ 自动 HTTPS
• ✅ 全球 CDN
• ✅ 无服务器函数
• ✅ 一键回滚

环境变量配置：

NODE_ENV=production
LOGIN_USERNAME=admin
LOGIN_PASSWORD_HASH=your_hash
DATABASE_URL=mysql://...

获取密码哈希：

npm run generate-password yourPassword

We welcome contributions! Please see our Contributing Guide for details.

# Clone repository
git clone https://github.com/erishen/nsgm.git
cd nsgm

# Install dependencies
npm install

# Run tests
npm test

# Build CLI
npm run tsbuild

• Security Guide - Security best practices
• API Reference - Complete API documentation
• Migration Guide - Upgrade instructions
• Troubleshooting - Common issues and solutions

Port already in use

# Kill process on port 3000
lsof -ti:3000 | xargs kill -9

# Or use different port
PORT=3001 npm run dev

Database connection failed

# Check MySQL service
sudo systemctl status mysql

# Verify credentials in .env
cat .env | grep DB_

Permission denied

# Fix npm permissions
sudo chown -R $(whoami) ~/.npm

# Or use different install location
npm config set prefix '~/.local'

This project is licensed under the MIT License - see the LICENSE file for details.

• Next.js - React framework
• GraphQL - Query language
• Styled Components - CSS-in-JS
• MySQL - Relational database