A CLI tool that generates a GraphQL API server and schema from an existing SQL database structure.
sql-to-graphql is a Node.js command-line tool that automatically generates a GraphQL API server and schema by analyzing the structure of an existing SQL database. It creates GraphQL types, resolvers, and a Hapi-based HTTP server, allowing developers to quickly expose their SQL data via GraphQL without manual setup. The tool is intended to help beginners learn GraphQL concepts and accelerate prototyping.
Developers new to GraphQL who want to quickly experiment with it using their existing SQL databases, or those looking for a rapid way to scaffold a GraphQL API for prototyping purposes.
It dramatically reduces the initial setup time for a GraphQL API by automating schema and resolver generation, supports multiple SQL databases, and includes a ready-to-use server and frontend for immediate testing.
Generate a GraphQL API based on your SQL database structure
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Generates a complete GraphQL server with types and resolvers from SQL tables in minutes, perfect for quick demos or learning, as highlighted in the description.
Works with MySQL, PostgreSQL, and SQLite, offering flexibility for common SQL databases without extra configuration, per the options list.
Creates resolvers for basic CRUD operations, eliminating manual coding for standard queries and mutations, reducing initial setup time.
Includes a web frontend for exploring and testing the GraphQL API immediately after generation, lowering the barrier for newcomers.
The README has a warning that the project is unmaintained, meaning no updates, bug fixes, or security patches, making it risky for any serious use.
Relies on simple naming conventions for inferring table connections, which the README admits is 'far from fool-proof' and fails with complex schemas.
Only supports basic GraphQL operations; lacks subscriptions, custom mutations, or advanced optimizations, restricting it to simple CRUD scenarios.
Uses Hapi for the HTTP server, which might not align with teams preferring other frameworks like Express, adding potential lock-in for generated code.