# sql_format

**Repository Path**: chenzechao/sql_format

## Basic Information

- **Project Name**: sql_format
- **Description**: No description available
- **Primary Language**: Java
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2026-06-26
- **Last Updated**: 2026-06-29

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# SQL Format Tool

Online SQL formatting tool with frontend-backend separation architecture.

## Features

- SQL formatting with configurable indent, keyword case
- SQL compression (single line)
- Syntax validation with error location
- Multi-database support: MySQL, Oracle, PostgreSQL, SQLServer
- File batch processing
- History management
- User config persistence

## Tech Stack

- **Frontend:** Vue3 + Vite + Element Plus + Monaco Editor
- **Backend:** SpringBoot 3.2 + Druid SQL Parser + MyBatis-Plus
- **Database:** MySQL 8.0

## Quick Start

### Database Setup

```sql
-- Run schema.sql to create database and tables
mysql -u root -p < backend/src/main/resources/db/schema.sql
```

### Backend

```bash
cd backend
mvn spring-boot:run
```

### Frontend

```bash
cd frontend
npm install
npm run dev
```

Open http://localhost:5173

## API Endpoints

| Method | Path | Description |
|--------|------|-------------|
| POST | /api/sql/format | Format SQL |
| POST | /api/sql/validate | Validate SQL |
| POST | /api/sql/compress | Compress SQL |
| POST | /api/sql/fileFormat | Batch format file |
| GET | /api/sql/history/list | List history |
| DELETE | /api/sql/history/{id} | Delete history |
| DELETE | /api/sql/history/clear | Clear history |
| GET | /api/sql/config/get | Get config |
| PUT | /api/sql/config/save | Save config |