GraphQL - APIs Generates

GraphQL APIs Generated Using Tool

Features


  • APIs
    • Generates GraphQL APIs for ANY MySql, Postgres, MSSQL, Sqlite database 🔥
    • Serves GraphQL queries irrespective of naming conventions of primary keys, foreign keys, tables etc 🔥
    • Support for composite primary keys 🔥
    • Usual suspects : CRUD, List, FindOne, Count, Exists, Distinct
    • Pagination
    • Sorting
    • Column filtering - Fields 🔥
    • Row filtering - Where 🔥
    • Bulk insert, Bulk delete, Bulk read 🔥
    • Relations - automatically detected
    • Aggregate functions
    • More
      • Upload single file
      • Upload multiple files
      • Download file
    • Authentication
  • Access Control

GraphQL API Overview



Query


Resolver Arguments Returns Description
TableNameList where: String, limit: Int, offset: Int, sort: String [TableName] List of table rows
TableNameRead id:String TableName Get row by primary key
TableNameExists id: String Boolean Check row exists by primary key
TableNameFindOne where: String TableName Find row by where conditions
TableNameCount where: String Int Get rows count
TableNameDistinct columnName: String, where: String, limit: Int, offset: Int, sort: String [TableName] Get distinct rows based on provided column names
TableNameGroupBy fields: String, having: String, limit: Int, offset: Int, sort: String [TableNameGroupBy] Group rows by provided columns
TableNameAggregate columnName: String!, having: String, limit: Int, offset: Int, sort: String, func: String! [TableNameAggregate] Do aggregation based on provided column name aggregate function
TableNameDistribution min: Int, max: Int, step: Int, steps: String, columnName: String! [distribution] Get distributed list

Mutations


Resolver Arguments Returns Description
TableNameCreate data:TableNameInput TableName Insert row into table
TableNameUpdate id:String,data:TableNameInput TableName Update table row using primary key
TableNameDelete id:String TableName Delete table row using primary id
TableNameCreateBulk data: [TableNameInput] [Int] Bulk row insert
TableNameUpdateBulk data: [TableNameInput] [Int] Bulk row update
TableNameDeleteBulk data: [TableNameInput] [Int] Bulk row delete

Query Arguments


Param Description Default value Example Value
where Logical Expression (colName,eq,colValue)~or(colName2,gt,colValue2)
Usage: Comparison operators
Usage: Logical operators
limit Number of rows to get(SQL limit value) 10 20
offset Offset for pagination(SQL offset value) 0 20
sort Sort column name, where use - as prefix for descending sort column_name
fields Required column names in result * column_name_1,column_name_2

Operators


Comparison Operators

Example use of comparison operators - complex example

Logical operators

Examples




TableNameList

Request

Response


⤴️


List + where

Request

Usage : comparison operators

Response


⤴️


List + where + sort

Request

Response


⤴️


List + limit

Request

Response


⤴️


List + where + sort + offset

Request

Response


⤴️


TableNameRead

Request

Response


⤴️

TableNameExists

Request

Response


⤴️

TableNameFindOne

Request

Response


⤴️

TableNameCount

Request

Response


⤴️

TableNameDistinct

Request

Response


⤴️

TableNameGroupBy

Request

Response


⤴️

TableNameAggregate

Request

Response


⤴️

TableNameDistribution

Request

Response


⤴️

TableNameCreate

Request

Response


⤴️

TableNameUpdate

Request

Response


⤴️

TableNameDelete

Request

Response


⤴️

TableNameCreateBulk

Request

Response


⤴️

TableNameUpdateBulk

Request

Response


⤴️

TableNameDeleteBulk

Request

Response


⤴️

Subscribe to Our Newsletter

Let us stretch your imagination

Download App