Skip to content

QueryDeck/querydeck

Repository files navigation

GitHub license

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

Navigation:

QueryDeck generates instant REST APIs for Postgres. 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 and toold 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

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

QueryDeck 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.

Contributors 4

  •  
  •  
  •  
  •