SQL by email

Send SQL wrapped in <sql> tags to:

Quick examples

• Check connection

  Simple sanity check that returns the current timestamp.

  Compose email

  <sql>
  SELECT NOW() AS now;
  </sql>

• Create users table

  Creates a basic users table if it does not exist.

  Compose email

  <sql>
  CREATE TABLE IF NOT EXISTS users (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(255) UNIQUE NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  );
  </sql>

• Insert sample users

  Adds a couple of example rows to the users table.

  Compose email

  <sql>
  INSERT INTO users (name, email) VALUES
    ('Alice Johnson', 'alice@example.com'),
    ('Bob Smith', 'bob@example.com');
  </sql>

• List users

  Returns all users ordered by most recent.

  Compose email

  <sql>
  SELECT * FROM users ORDER BY created_at DESC;
  </sql>

Add yourself

Type your name and we will prefill an email that inserts it into the users table.