pREST is a production-grade Go HTTP server that automatically exposes PostgreSQL databases as RESTful and MCP (Model Context Protocol) APIs without requiring hand-written backend code. It provides instant CRUD endpoints for any table, custom SQL template execution with parameterized queries, and a built-in Studio web UI for exploring and managing APIs. The system is architected around a hexagonal pattern with a clean adapter interface supporting multiple databases (PostgreSQL, TimescaleDB), dependency injection for controllers, and a layered middleware stack for authentication (JWT), authorization (table/field-level ACL), caching, and CORS. Security is a primary concern: SQL injection is mitigated through strict identifier validation, template parameter screening, and bound parameter binding, while credential leakage in logs is prevented by a dedicated redaction package. The codebase is well-tested with both unit tests (using sqlmock) and integration tests (against real PostgreSQL in Docker), and includes OpenTelemetry integration for observability. It is not a data research or analytics project; it is a pure application for building low-code database APIs.
This is an example application demonstrating how to set up and run a Parse Server instance using Express. It serves as a reference implementation for the Parse Server open-source backend-as-a-service. The codebase includes a minimal Express server that mounts the Parse Server middleware at a configurable path, serves static assets and a test page, and provides health check endpoints. It uses modern ES6 modules, TypeScript, and the latest Parse Server version (9.x). Cloud code functions (hello, beforeSave) and schema definitions are included to illustrate common patterns. The project also includes comprehensive deployment configurations for various platforms (Heroku, AWS, Google Cloud, etc.), Docker support, CI/CD with GitHub Actions, and automated semantic releases. While simple in scope, the code is well-structured, follows current best practices, and includes a test suite with a reusable test runner utility for programmatically starting/stopping the server during integration tests. This repository is best used as a starter template for new Parse Server projects or as a reference for migration to Parse Server 8+.