joehoover/sql-generator:701d006c – Run with an API on Replicate

Version

Fast booting

You're looking at a specific version of this model. Jump to the model overview.

joehoover /sql-generator:701d006c

Playground API

Input

prompt

*string

Shift + Return to add a new line

Prompt to send to the model.

max_new_tokens

integer

(minimum: 1)

Maximum number of tokens to generate. A word is generally 2-3 tokens

Default: 128

min_new_tokens

integer

(minimum: -1)

Minimum number of tokens to generate. To disable, set to -1. A word is generally 2-3 tokens.

Default: -1

temperature

number

(minimum: 0.01, maximum: 5)

Adjusts randomness of outputs, greater than 1 is random and 0 is deterministic, 0.75 is a good starting value.

Default: 0.75

top_p

number

(minimum: 0, maximum: 1)

When decoding text, samples from the top p percentage of most likely tokens; lower to ignore less likely tokens

Default: 0.9

top_k

integer

(minimum: 0)

When decoding text, samples from the top k most likely tokens; lower to ignore less likely tokens

Default: 50

stop_sequences

string

Shift + Return to add a new line

A comma-separated list of sequences to stop generation at. For example, '<end>,<stop>' will stop generation at the first instance of 'end' or '<stop>'.

seed

integer

Random seed. Leave blank to randomize the seed

debug

boolean

provide debugging output in logs

Default: false

Run this model in Node.js with one line of code:

npx create-replicate --model=joehoover/sql-generator

or set up a project from scratch

Install Replicate’s Node.js client library:

npm install replicate

Set the REPLICATE_API_TOKEN environment variable:

export REPLICATE_API_TOKEN=<paste-your-token-here>

Find your API token in your account settings.

Import and set up the client:

import Replicate from "replicate";

const replicate = new Replicate({
  auth: process.env.REPLICATE_API_TOKEN,
});

Run joehoover/sql-generator using Replicate’s API. Check out the model's schema for an overview of inputs and outputs.

const output = await replicate.run(
  "joehoover/sql-generator:701d006cebfe9ed85182c74bccd8d813789033a5fce723bb4e03355c0e3516d2",
  {
    input: {
      debug: false,
      top_k: 50,
      top_p: 0.9,
      temperature: 0.75,
      max_new_tokens: 128,
      min_new_tokens: -1
    }
  }
);
console.log(output);

To learn more, take a look at the guide on getting started with Node.js.

Install Replicate’s Python client library:

pip install replicate

Set the REPLICATE_API_TOKEN environment variable:

export REPLICATE_API_TOKEN=<paste-your-token-here>

Find your API token in your account settings.

Import the client:

import replicate

Run joehoover/sql-generator using Replicate’s API. Check out the model's schema for an overview of inputs and outputs.

output = replicate.run(
    "joehoover/sql-generator:701d006cebfe9ed85182c74bccd8d813789033a5fce723bb4e03355c0e3516d2",
    input={
        "debug": False,
        "top_k": 50,
        "top_p": 0.9,
        "temperature": 0.75,
        "max_new_tokens": 128,
        "min_new_tokens": -1
    }
)

# The joehoover/sql-generator model can stream output as it's running.
# The predict method returns an iterator, and you can iterate over that output.
for item in output:
    # https://replicate.com/joehoover/sql-generator/api#output-schema
    print(item, end="")

To learn more, take a look at the guide on getting started with Python.

Set the REPLICATE_API_TOKEN environment variable:

export REPLICATE_API_TOKEN=<paste-your-token-here>

Find your API token in your account settings.

Run joehoover/sql-generator using Replicate’s API. Check out the model's schema for an overview of inputs and outputs.

curl -s -X POST \
  -H "Authorization: Bearer $REPLICATE_API_TOKEN" \
  -H "Content-Type: application/json" \
  -H "Prefer: wait" \
  -d $'{
    "version": "701d006cebfe9ed85182c74bccd8d813789033a5fce723bb4e03355c0e3516d2",
    "input": {
      "debug": false,
      "top_k": 50,
      "top_p": 0.9,
      "temperature": 0.75,
      "max_new_tokens": 128,
      "min_new_tokens": -1
    }
  }' \
  https://api.replicate.com/v1/predictions

To learn more, take a look at Replicate’s HTTP API reference docs.

You can run this model locally using Cog. First, install Cog:

brew install cog

If you don’t have Homebrew, there are other installation options available.

Run this to download the model and run it in your local environment:

cog predict r8.im/joehoover/sql-generator@sha256:701d006cebfe9ed85182c74bccd8d813789033a5fce723bb4e03355c0e3516d2 \
  -i 'debug=false' \
  -i 'top_k=50' \
  -i 'top_p=0.9' \
  -i 'temperature=0.75' \
  -i 'max_new_tokens=128' \
  -i 'min_new_tokens=-1'

To learn more, take a look at the Cog documentation.

Run this to download the model and run it in your local environment:

docker run -d -p 5000:5000 --gpus=all r8.im/joehoover/sql-generator@sha256:701d006cebfe9ed85182c74bccd8d813789033a5fce723bb4e03355c0e3516d2
curl -s -X POST \
  -H "Content-Type: application/json" \
  -d $'{
    "input": {
      "debug": false,
      "top_k": 50,
      "top_p": 0.9,
      "temperature": 0.75,
      "max_new_tokens": 128,
      "min_new_tokens": -1
    }
  }' \
  http://localhost:5000/predictions

To learn more, take a look at the Cog documentation.

Output

No output yet! Press "Submit" to start a prediction.