Create and manage SQL databases.
No hosting service needed.
No SQL server management studio needed.

To get started, use the API calls below.
An account is required in order to be able to create an SQL database.
Email address is required.
Email must exist and must be valid, otherwise you will not be able to access your account.
To access your account, you will have to pass to the EmailAddress parameter in the API, the email address you provided when you created your account, and an authorization key will be sent to that email address.
Open your email and copy the authorization key and pass it to the AuthorizationKey parameter in the API.

Phone number is not required but is necessary.
In the event there's an issue with your email and you cannot receive the authorization key, or in the event there's a delay in the delivery of the authorization key to your email, the authorization key can be sent to you by text message.
To get started, use the API calls below.

Create Account API

Command line: Windows:
C:\Users\yourusername>curl -X POST https://ew3.site/api/SqlApi/AccountSetup
-H "Content-Type: application/json"
-d "{\"EmailAddress\": \"your email address\", \"Phone\": \"your phone number\"}"

JavaScript:
<script>
async function apiAccountSetup(apiurl = "", apidata = {}) {
const response = await fetch(apiurl, {
method: "POST",
cache: "no-cache",
headers: {
"Content-Type": "application/json",
},
body: JSON.stringify(apidata)
});
return response.json();
}

const endpoint = "https://ew3.site/api/SqlApi/AccountSetup";
const params = {"EmailAddress": "your email address", "Phone": "your phone number"};
// Call the function above
apiAccountSetup(endpoint, params).then((data) => {
console.log(data);
alert(data);
});
</script>

Create Database API

Command line: Windows:
C:\Users\yourusername>curl -X POST https://ew3.site/api/SqlApi/CreateDatabase
-H "Content-Type: application/json"
-d "{\"DatabaseName\": \"database name\", \"AuthorizationKey\": \"authorization key sent to your email\"}"

JavaScript:
<script>
async function apiCreateDatabase(apiurl = "", apidata = {}) {
const response = await fetch(apiurl, {
method: "POST",
cache: "no-cache",
headers: {
"Content-Type": "application/json",
},
body: JSON.stringify(apidata)
});
return response.json();
}

const endpoint = "https://ew3.site/api/SqlApi/CreateDatabase";
const params = {"DatabaseName": "database name", "AuthorizationKey": "authorization key sent to your email"};
// Call the function above
apiCreateDatabase(endpoint, params).then((data) => {
console.log(data);
alert(data);
});
</script>

Create Table API

Command line: Windows:
C:\Users\yourusername>curl -X POST https://ew3.site/api/SqlApi/CreateTable
-H "Content-Type: application/json"
-d "{\"DatabaseName\": \"database name\", \"TableName\": \"table name\",\"CrudData\": '{ "id": "int identity(1, 1) not null", "column1": "varchar(50) null","column2": "varchar(50) null","column3": "varchar(100) null","column4": "varchar(50) null"...}', \"AuthorizationKey\": \"authorization key sent to your email\"}"

JavaScript:
<script>
async function apiCreateTable(apiurl = "", apidata = {}) {
const response = await fetch(apiurl, {
method: "POST",
cache: "no-cache",
headers: {
"Content-Type": "application/json",
},
body: JSON.stringify(apidata)
});
return response.json();
}

const endpoint = "https://ew3.site/api/SqlApi/CreateTable";
const params = {"DatabaseName": "database name","TableName": "table name","CrudData": `{ "id": "int identity(1, 1) not null", "column1": "varchar(50) null","column2": "varchar(50) null","column3": "varchar(100) null","column4": "varchar(50) null"...}`, "AuthorizationKey": "authorization key sent to your email"};
// Call the function above
apiCreateTable(endpoint, params).then((data) => {
console.log(data);
alert(data);
});
</script>

Get List Of Database Tables API

Command line: Windows:
C:\Users\yourusername>curl -X POST https://ew3.site/api/SqlApi/GetListOfTables
-H "Content-Type: application/json"
-d "{\"DatabaseName\": \"database name\", \"AuthorizationKey\": \"authorization key sent to your email\"}"

JavaScript:
<script>
async function apiGetListOfTables(apiurl = "", apidata = {}) {
const response = await fetch(apiurl, {
method: "POST",
cache: "no-cache",
headers: {
"Content-Type": "application/json",
},
body: JSON.stringify(apidata)
});
return response.json();
}

const endpoint = "https://ew3.site/api/SqlApi/GetListOfTables";
const params = {"DatabaseName": "database name", "AuthorizationKey": "authorization key sent to your email"};
// Call the function above
apiGetListOfTables(endpoint, params).then((data) => {
console.log(data);
alert(data);
});
</script>

Get Table Columns API

Command line: Windows:
C:\Users\yourusername>curl -X POST https://ew3.site/api/SqlApi/apiGetTableColumns
-H "Content-Type: application/json"
-d "{\"DatabaseName\": \"database name\", \"TableName\": \"table name\", \"AuthorizationKey\": \"authorization key sent to your email\"}"

JavaScript:
<script>
async function apiGetListOfTables(apiurl = "", apidata = {}) {
const response = await fetch(apiurl, {
method: "POST",
cache: "no-cache",
headers: {
"Content-Type": "application/json",
},
body: JSON.stringify(apidata)
});
return response.json();
}

const endpoint = "https://ew3.site/api/SqlApi/apiGetTableColumns";
const params = {"DatabaseName": "database name", "TableName": "table name", "AuthorizationKey": "authorization key sent to your email"};
// Call the function above
apiGetTableColumns(endpoint, params).then((data) => {
console.log(data);
alert(data);
});
</script>

Create Table Row API

Command line: Windows:
C:\Users\yourusername>curl -X POST https://ew3.site/api/SqlApi/CreateTableRow
-H "Content-Type: application/json"
-d "{\"DatabaseName\": \"database name\", \"TableName\": \"table name\", \"PrimaryKey\": \"table primary key\", \"CrudData\": '{ \"column1\": \"column1 value\", \"column2\": \"column2 value\", \"column3\": \"column3 value\", \"column4\": \"column4 value\" ...}', \"AuthorizationKey\": \"authorization key sent to your email\"}"

JavaScript:
<script>
async function apiCreateTableRow(apiurl = "", apidata = {}) {
const response = await fetch(apiurl, {
method: "POST",
cache: "no-cache",
headers: {
"Content-Type": "application/json",
},
body: JSON.stringify(apidata)
});
return response.json();
}

const endpoint = "https://ew3.site/api/SqlApi/CreateTableRow";
const params = {"DatabaseName": "database name",
"TableName": "table name",
"PrimaryKey": "table primary key",
"CrudData": `{ "column1": "column1 value",
"column2": "column2 value",
"column3": "column3 value",
"column4": "column4 value"
...
}`,
"AuthorizationKey": "authorization key sent to your email"
};
// Call the function above
apiCreateTableRow(endpoint, params).then((data) => {
console.log(data);
alert(data);
});
</script>

Select Table Data API

Command line: Windows:
C:\Users\yourusername>curl -X POST https://ew3.site/api/SqlApi/SelectTableData
-H "Content-Type: application/json"
-d "{\"DatabaseName\": \"database name\", \"TableName\": \"table name\", \"PrimaryKey\": \"table primary key\", \"CrudData\": '{ "numberofrowstoselect": "number of rows to select", "orderbycolumnname": "column you want to sort selected data on", "ascdesc": "asc or desc", "selectcolumns": "column1, column2, column3, column4..."}', \"AuthorizationKey\": \"authorization key sent to your email\"}"

JavaScript:
<script>
async function apiSelectTableData(apiurl = "", apidata = {}) {
const response = await fetch(apiurl, {
method: "POST",
cache: "no-cache",
headers: {
"Content-Type": "application/json",
},
body: JSON.stringify(apidata)
});
return response.json();
}

const endpoint = "https://ew3.site/api/SqlApi/SelectTableData";
const params = {"DatabaseName": "database name",
"TableName": "table name",
"PrimaryKey": "table primary key",
"CrudData": `{ "numberofrowstoselect": "number of rows to select",
"orderbycolumnname": "column you want to sort selected data on",
"ascdesc": "asc or desc",
"selectcolumns": "column1, column2, column3, column4..."
}`,
"AuthorizationKey": "authorization key sent to your email"
};
// Call the function above
apiSelectTableData(endpoint, params).then((data) => {
console.log(data);
alert(data);
});
</script>

Update Table Row API

Command line: Windows:
C:\Users\yourusername>curl -X POST https://ew3.site/api/SqlApi/UpdateTableRow
-H "Content-Type: application/json"
-d "{\"DatabaseName\": \"database name\", \"TableName\": \"table name\", \"PrimaryKey\": \"table primary key\", \"PrimaryKeyValue\": \"Value (integer) of primary key where to do the update\", \"CrudData\": '{ "column1": "column1 value", "column2": "column2 value", "column3": "column3 value", "column4": "column4 value" }', \"AuthorizationKey\": \"authorization key sent to your email\"}"

JavaScript:
<script>
async function apiUpdateTableRow(apiurl = "", apidata = {}) {
const response = await fetch(apiurl, {
method: "POST",
cache: "no-cache",
headers: {
"Content-Type": "application/json",
},
body: JSON.stringify(apidata)
});
return response.json();
}

const endpoint = "https://ew3.site/api/SqlApi/UpdateTableRow";
const params = {"DatabaseName": "database name",
"TableName": "table name",
"PrimaryKey": "table primary key",
"PrimaryKeyValue": "Value (integer) of primary key where to do the update",
"CrudData": `{ "column1": "column1 value",
"column2": "column2 value",
"column3": "column3 value",
"column4": "column4 value"
...
}`,
"AuthorizationKey": "authorization key sent to your email"
};
// Call the function above
apiUpdateTableRow(endpoint, params).then((data) => {
console.log(data);
alert(data);
});
</script>