SQLGen is a command-line tool written in Go that helps you generate SQL queries efficiently.
- Generate basic SQL queries for PostgreSQL and MySQL
To install SQLGen, you need to have Go installed on your machine. Then, you can use the following command to install SQLGen:
# postgresgo install github.com/miyataka/sqlgen/cmd/psqlgen@latest# mysqlgo install github.com/miyataka/sqlgen/cmd/mysqlgen@latest
After installing SQLGen, you can use it from the command line. Here are some examples of how to use SQLGen:
# Generate SQL queries for PostgreSQLpsqlgen --dsn="postgres://user:password@localhost:5432/dbname"# Generate SQL queries for MySQLmysqlgen --dsn="user:password@tcp(localhost:3306)/dbname"
When using with sqlc, you can generate comment for sqlc with just--sqlc flag:
# Generate SQL queries for PostgreSQL with comments for sqlcpsqlgen --dsn="postgres://user:password@localhost:5432/dbname" --sqlc# Generate SQL queries for MySQL with comments for sqlcmysqlgen --dsn="user:password@tcp(localhost:3306)/dbname" --sqlc
We welcome contributions to SQLGen! If you have any ideas, suggestions, or bug reports, please open an issue or submit a pull request on GitHub.
This project is licensed under the MIT License.
