FreeSQL

Loading...
How-toOpen web editor

One-click and free
SQLite databases

Create Database

How to use the API

curl -X POST https://free-sql.com/api/ \
-u database:password \
-d "SELECT sqlite_version();"
To use the API, send a POST request to the specified API endpoint with the necessary authentication credentials and the desired SQL query in the request body. For example, you can use curl to execute a command that retrieves data from a specific table in your SQLite database.

Create your first database table in SQL

curl -X POST https://free-sql.com/api/ \
-u database:password \
-d "CREATE TABLE your_table (id INTEGER PRIMARY KEY, name TEXT NOT NULL, age INTEGER, email TEXT UNIQUE);"
Creating your first table in SQLite is an essential step in managing your database. By following the simple steps outlined above, you can define the structure of your table and begin storing data efficiently. Whether you choose to use the SQLite command line or an API, the process is straightforward and user-friendly.

Limitations

  • Max 10MB
  • Max 14 days inactive
  • Max 100 requests per minute
Databases have a maximum size of 10 MB, after which write operations will be disabled. Additionally, if a database remains inactive for 14 days or more, it will be permanently removed. Users should regularly back up their data to prevent loss, especially if they anticipate extended periods of inactivity. Users can make up to 100 requests per minute to ensure service stability and reliability.