# alash3al/sqler

write APIs using direct SQL queries with no hassle, let's rethink about SQL

Repository: https://github.com/alash3al/sqler
Canonical: https://ross.abutalabs.com/products/sqler
Language: Go
License: Apache-2.0
License Family: permissive
Topics: mysql, sqlite3, postgresql, cockroach, mssql, api-rest, restful, baas
Last push: 2024-12-28T18:30:08+00:00

## Health v2 (maintenance only)
Score: 23/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 0, release rhythm 8, longevity 100
- inputs: {"age_days": 2795, "days_push": 613, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2068, forks 119 (observed 2026-08-28T04:06:10.238103+00:00)

## What it is
SQLer is a tiny standalone Go server that turns SQL queries into RESTful APIs, configured via HCL files with named macros. It supports MySQL, PostgreSQL, SQLite, SQL Server, and CockroachDB, with request validation, JavaScript-based data transformation, webhook authorizers, cron scheduling, and a Redis-protocol (RESP) interface.

## Use cases
- expose database queries as REST APIs without writing backend code
- build a quick backend-as-a-service on top of MySQL or PostgreSQL
- validate request params and transform query results with JavaScript
- schedule SQL jobs with cron syntax
- query a database over the Redis protocol using any Redis client
- secure SQL-backed endpoints with webhook-based authorization

## When to choose
- you want CRUD-style APIs from SQL queries with minimal setup
- you need a lightweight standalone server with no runtime dependencies
- your data lives in MySQL, Postgres, SQLite, MSSQL, or CockroachDB
- you want built-in validation, transformation, and scheduling in one tool

## When to avoid
- you need complex business logic beyond simple JavaScript transformations
- you require a full ORM or rich application framework
- you need non-SQL datastores like MongoDB or document stores
- you need fine-grained row-level security or advanced auth flows

## Facets
- artifact type: service
- maturity: maintenance
- function: http-server, api-framework, database, database-driver, webhook, scheduling, middleware
- domain: backend, apis, databases, web-development, self-hosted
- platform: windows, self-hosted, go
- tags: sql-to-rest, baas, hcl-config, redis-protocol, macro, prepared-statements, javascript-transformations, linux, macos, docker

## Member repositories
- alash3al/sqler (main) score 23

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:06:10.238103+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T02:56:46.937118+00:00, confidence not recorded.
  - readme: https://github.com/alash3al/sqler (fetched 2026-08-28T04:06:10.238103+00:00, sha fb4e86ae3a0e)
- Data as of 2026-08-30T08:39:29.467469+00:00.