ngaut/sqler

SQLer lets you build web APIs directly from SQL queries without writing any backend code. Instead of writing traditional server logic, you write a configuration file that describes what SQL queries should run when someone makes a web request, then SQLer handles the rest. When someone hits an endpoint like /adduser, SQLer runs the SQL query you've defined for that endpoint, validates the incoming data (like checking that an email looks valid), executes the query safely, and returns the result. You can also transform the data using simple JavaScript code if you want to reshape it before sending it back to the user. The whole thing is portable, it's a single Go program with no external dependencies, so you can run it anywhere. The tool works with almost any SQL database you might already use: MySQL, PostgreSQL, SQLite, SQL Server, and several others. It gives you two ways to access your queries. One is a traditional REST API over HTTP, you make web requests and get JSON back, with built-in support for checking authorization through external webhooks. The other is a Redis-compatible interface, which means you can connect using any Redis client and execute your queries as Redis commands. This flexibility means developers familiar with either approach can use what they're comfortable with. SQLer is particularly useful if you have a straightforward data layer and don't want the overhead of building a full backend service. A startup MVP, a rapidly changing internal tool, or a small team that wants to ship quickly might use this to turn database operations into APIs in minutes rather than hours. The configuration uses HCL (the same language nginx uses), which is meant to be readable, and you get built-in features like request validation, data hashing, and automatic protection against SQL injection through prepared statements, so you're not sacrificing safety for speed.