SheetsDB — Google Sheets Database

Create Table

Table Name

Columns JSON array

List Tables

Fetch all user-created tables in the spreadsheet.

Describe Table

Table Name

Rename Table

Old Name

New Name

Drop Table

Permanently delete a table and all its data.

Table Name

SELECT Query

Table

Where e.g. age>18;name=John

Select comma-separated

Sort -age = desc, +name = asc

Limit

Offset

Insert Rows

Table

Bulk Insert

Record JSON object

UPDATE Rows

Table

Where e.g. id=4

Values JSON object

DELETE Rows

Rows matching the where clause will be permanently removed.

Table

Where e.g. id=4

Add Column

Table

Column Name

Type

Remove Column

Table

Column

Rename Column

Table

Old Name

New Name

Change Column Type

Table

Column

New Type

Create Table

List Tables

Describe Table

Rename Table

Drop Table

SELECT Query

Insert Rows

UPDATE Rows

DELETE Rows

Add Column

Remove Column

Rename Column

Change Column Type

Response