QueryDeck

Note: QueryDeck is currently in beta. While fully functional, you may encounter occasional issues as we continue to improve the platform.

Navigation:

• Features
  • Visual API Builder
  • Multi-Engine Support
  • Automated Schema Analysis
  • Instant Deployment
  • Security & Access Control
  • Developer Tools
• Demo
• Installation
• Documentation

QueryDeck generates RESTful APIs from existing SQL databases. Use the visual no-code builder to create complex SQL queries with deep joins, nested inserts, dynamic parameters and turn them into fully functional REST APIs. Deploy your APIs instantly or push them as a Nodejs app to your GitHub repository.

Features

Visual API Builder

Build complex APIs without writing SQL code:

• Deep Join Support:
  • Create sophisticated multi-table relationships
  • Visual join builder for complex data structures
  • Optimize query performance automatically
• Nested Insert Operations:
  • Handle hierarchical data operations in single API calls
  • Maintain data integrity across related tables
  • Automatic transaction management
• Dynamic Query Parameters:
  • Flexible parameter configuration
  • Runtime query customization
  • Support for complex filtering and sorting

Multi-Engine Support

Compatible with major SQL databases:

• PostgreSQL
• MySQL
• Microsoft SQL Server

Automated Schema Analysis

• Intelligent Schema Introspection: Automatically maps and analyzes your database structure
• Visual Schema Graph: Interactive visualization of database relationships and table connections
• Real-time Schema Updates: Keeps your API in sync with database changes

Instant Deployment

• Zero-configuration deployment
• Automatic API endpoint generation
• Built-in load balancing and scaling

Security & Access Control

• Authentication: Built-in auth system with multiple providers
• Role-Based Access Control (RBAC):
  • Granular permission management
  • Table-level and column-level security
  • Custom access policies

Developer Tools

• Node.js Export: Convert your API into a standalone Node.js application
• GitHub Integration: Direct export to GitHub repositories
• API Documentation: Automatic generation of OpenAPI/Swagger documentation

🎥 Demo

🛠️ Installation

For detailed installation instructions, please refer to our Installation Guide.

📖 Documentation

Visit our Documentation for:

• Getting Started Guide
• API Reference
• Best Practices
• Example Projects
• Troubleshooting

For additional support, please contact us directly via email.