What is Apizzer?
Apizzer is a specialized tool that transforms SQL Server databases into fully functional APIs without requiring any manual coding. It enables users to map database objects such as tables, views, and stored procedures directly to API endpoints, with all configurations stored in metadata for resilience against changes. The platform supports self-hosted deployment on private infrastructure, ensuring data security and compliance while providing granular control over authentication, documentation, rate limiting, and other API parameters.
With features like automatic OpenAPI documentation generation, JWT authentication, and support for various HTTP methods, Apizzer simplifies API development for internal or public use. It includes advanced capabilities such as file folder exposure, caching, pagination, and telemetry logging, making it suitable for both simple and complex integration scenarios. The tool is designed for users who need to quickly and securely expose database functionality through APIs while maintaining full customization and control over the entire process.
Features
- Metadata-driven mapping: Map tables, views, and stored procedures to API endpoints with configurations stored in metadata for change resistance.
- Granular API control: Customize authentication, documentation, rate limits, logging, headers, CORS, compression, pagination, caching, security, and request types.
- Auto-create documentation: Automatically generate OpenAPI-compliant documentation with Swagger UI rendering and customizable descriptions.
- Self-hosted deployment: Deploy securely on your own infrastructure without exposing the database directly, maintaining full control and compliance.
- JWT Authentication: Use SQL Server users and roles as identity sources with secure, encrypted authentication via JWT tokens.
Use Cases
- Exposing SQL Server data as APIs for internal applications
- Building public APIs for external clients or partners
- Automating API creation for database-driven projects without coding
- Securing database access through controlled API endpoints
- Generating API documentation automatically for development teams
FAQs
-
Which database engines are supported by Apizzer?
Apizzer targets Microsoft SQL Server 2012 and newer, including Azure SQL, to fully utilize SQL Server-specific features without compromises. -
What security mechanisms protect APIs created with Apizzer?
Authentication uses JWT tokens for SQL Server logins, with authorization based on database roles, plus configurable per-endpoint role matrices, CORS, and rate limits. -
Which operating systems can run Apizzer components?
Windows 10/11 (64-bit) and Windows Server 2019, 2022, 2025. -
How do I scale Apizzer for high availability?
The Web API is stateless, so horizontal scaling involves starting multiple instances behind a reverse proxy or load balancer. -
How is API versioning handled in Apizzer?
You can publish different API versions (e.g., v1 and v2) to separate base URLs, allowing coexistence until consumers migrate.
Helpful for people in the following professions
Apizzer Uptime Monitor
Average Uptime
55.83%
Average Response Time
400.8 ms
