Mysql Graphql Generator for Graph Database

Hasura provides robust support for MySQL databases, enabling developers to leverage the power of GraphQL APIs seamlessly. The integration allows for automatic generation of GraphQL APIs based on the existing database schema, making it easier to interact with data.

Table of Contents

Getting Started with MySQL in Hasura

To begin using MySQL with Hasura, you can follow the guides tailored for different environments:

For Hasura Cloud, refer to the Getting Started with MySQL in Hasura Cloud.
For Docker environments, check the Getting Started with Docker.

Supported Versions

Hasura’s MySQL integration is available from version v2.24.0 onwards and supports standard implementations of MySQL 8.0 and higher. This includes popular cloud providers such as:

Amazon RDS
Amazon Aurora
Google Cloud SQL
Digital Ocean

However, it’s important to note that PlanetScale and certain other providers are not supported.

Supported Features

Hasura currently supports a variety of features for MySQL, including:

Queries: Execute complex queries to retrieve data efficiently.
Mutations: Perform data modifications with INSERT, UPDATE, and DELETE operations.
Table Relationships: Define relationships between tables to facilitate data retrieval.
Remote Relationships: Connect to external data sources and integrate them into your GraphQL API.
Permissions: Manage access control to ensure data security.

Limitations

While Hasura offers extensive support for MySQL, there are some limitations to be aware of:

Schema Modifications: Currently, Hasura does not support modifying the database schema directly. Therefore, the database should already contain the necessary tables and data before connecting to Hasura.
Access Requirements: Ideally, you should have access to the database outside of Hasura for any schema modifications.

Conclusion

In summary, Hasura’s integration with MySQL provides a powerful way to build GraphQL APIs quickly and efficiently. By utilizing features such as queries, mutations, and relationships, developers can create dynamic applications that interact with their MySQL databases effectively. For more detailed information, refer to the official documentation.