API Maker Logo
Features ▸ 8 Database support out of the box

8 Database Types Supported In CRUD APIs

This deep populate feature is supported in all types of databases and supported in all APIs, which returns data.

Fastest API development tool

Auto generation of APIs for MongoDB database

Auto generation of APIs for MySQL database

Auto generation of APIs for MariaDB database

Auto generation of APIs for PostgreSQL database

Auto generation of APIs for Oracle database

Auto generation of APIs for SQL Server database

Auto generation of APIs for TiDB

Auto generation of APIs for Percona XtraDB

Auto generation of APIs for Redis database

API Maker is the best tool for automatic API generation

Fastest API generation for databases

Superfast APIs automatically generated by API Maker

SAVA Info System Private Limited : ISO 9001 Certified Company

API Maker® Developed by SAVA - ISO 9001 Certified Company

MongoDB

-- Find data from mongodb

MySQL

-- Get city data from mysql

SQL Server

-- Get states data from sql server database

Maria DB

-- Get countries data from maria database

Oracle DB

-- Get continent data from database

PostgreSQL DB

-- Get planets data from postgresql database

Ti DB

-- Get planets data from TI database

Percona XtraDB

-- Get planets data from Percona Xtra database

⭐️ One GET API call can get data from N number of different types of databases with N number of data complexity.

⭐️ Stream APIs can stream huge amount of data.

️⭐️ In our custom APIs, we can get huge data as one by one object so we can process them one by one.

️⭐️ If caching is enabled in any table/collection, it can leverage that and speed up the process.

8 Database support request body

                      
{
  "find": {
    "person_name": "Kishan"
  },
  "deep": [
    {
      "s_key": "street_id",
      "t_key": "id",
      "t_table": "streets",
      "deep": [
        {
          "s_key": "area_id",
          "t_key": "id",
          "t_table": "areas",
          "deep": [
            {
              "s_key": "city_id",
              "t_key": "id",
              "t_table": "cities",
              "deep": [
                {
                  "s_key": "state_id",
                  "t_key": "id",
                  "t_table": "states",
                  "deep": [
                    {
                      "s_key": "country_id",
                      "t_key": "id",
                      "t_table": "countries",
                      "deep": [
                        {
                          "s_key": "continent_id",
                          "t_key": "id",
                          "t_table": "continents",
                          "deep": [
                            {
                              "s_key": "planet_id",
                              "t_key": "id",
                              "t_table": "planets",
                              "deep": [
                                {
                                "s_key": "galexy_id",
                                "t_key": "id",
                                "t_table": "galaxies"
                                }
                              ]
                            }
                          ]
                        }
                      ]
                    }
                  ]
                }
              ]
            }
          ]
        }
      ]
    }
  ]
}

Response from 8 different databases

                      
{
    "person_name": "Kishan",
    "street_id": { // from MongoDB
        "id": 12,
        "street_name": "TIRUPATI",
        "area_id": { // from MySQL
            "id": 24,
            "area_name": "RANIP",
            "city_id": { // from SQL_SERVER
                "id": 382480,
                "city_name": "AHMEDABAD",
                "state_id": { // from MariaDB
                    "id": 91,
                    "state_name": "GUJARAT",
                    "country_id": { // from Oracle
                        "id": 4,
                        "country_name": "INDIA",
                        "continent_id": { // from PostgreSQL
                            "id": 3,
                            "countinent_name": "ASIA"
                            "planet_id": { // from Ti DB
                                "id": 2,
                                "planet_name": "EARTH"
                                "galexy_id": { // from Percona XtraDB
                                    "id": 1,
                                    "galaxies_name": "Milky Way"
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}

Save/Update in 8 databases in one API call

MongoDB

-- Find data from mongodb

MySQL

-- Get city data from mysql

SQL Server

-- Get states data from sql server database

Maria DB

-- Get countries data from maria database

Oracle DB

-- Get continent data from database

PostgreSQL DB

-- Get planets data from postgresql database

Ti DB

-- Get planets data from TI database

Percona XtraDB

-- Get planets data from Percona Xtra database

⭐️ One GET API call can get data from N number of different typea of databases with N number of data complexity.

⭐️ Moreover we can stream data also, we can get a huge amount of data also.

️⭐️ In our custom APIs, we can get huge data as one by one object so we can process them one by one.

Master save request body

                      
{
    "person_name": "Kishan",
    "street_id": { // for MongoDB
        "id": 12,
        "street_name": "TIRUPATI",
        "area_id": { // for MySQL
            "id": 24,
            "area_name": "RANIP",
            "city_id": { // for SQL_SERVER
                "id": 382480,
                "city_name": "AHMEDABAD",
                "state_id": { // for MariaDB
                    "id": 91,
                    "state_name": "GUJARAT",
                    "country_id": { // for Oracle
                        "id": 4,
                        "country_name": "INDIA",
                        "continent_id": { // for PostgreSQL
                            "id": 3,
                            "continent_name": "ASIA"
                            "planet_id": { // for Ti DB
                                "id": 2,
                                "planet_name": "EARTH"
                                "galexy_id": { // for Percona XtraDB
                                    "id": 1,
                                    "galaxies_name": "Milky Way"
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}

Master Save Response

                      
{
    "_id": "6458d476462d139b9181e3d7",
    "person_name": "Kishan",
    "street_id": 5555
}

Find-join from any databases in one API call

Get list of orders of product "iPhone 14 Pro" of users with name "James".
Database tables can be in any different type of databases.

Find join data relationship

Find-join request body

                      
{
    "find": {
        "product_id.name": "iPhone 14 Pro",
        "user_id.name": "James"
    }
}

List of orders

                      
{
    "success": true,
    "statusCode": 200,
    "data": [
        {
            "id": 2,
            "product_id": 1,
            "price": 1200,
            "currency": "USD",
            "user_id": 2
        }
    ]
}
API MakerAPI Maker Logo

Mail contact@apimaker.dev

ISO Certificate logo Certificate image

Contact us

FAQ

Terms And Conditions

Privacy Policy

Visitors: 0 Facebook DEV Community Linkedin Youtube Twitter Discord

API Maker®. All rights reserved 2024 Developed by : SAVA - ISO 9001 Certified Company Developed by : SAVA - ISO 9001 Certified Company

↑