muqtadar08/finetuned_gemma_sql_generator | Run with an API on Replicate

Input

question

*string

Shift + Return to add a new line

Ask a Question to query you Database

ddl_doc

*string

Shift + Return to add a new line

CREATE TABLE products (
    product_id INT,
    product_name VARCHAR(100),
    category VARCHAR(50),
    price DECIMAL(10, 2),
    stock_quantity INT
);

INSERT INTO products (product_id, product_name, category, price, stock_quantity)
VALUES
    (1, 'Smartphone', 'Electronics', 599.99, 100),
    (2, 'Laptop', 'Electronics', 999.99, 50),
    (3, 'Headphones', 'Electronics', 99.99, 200),
    (4, 'T-shirt', 'Apparel', 19.99, 300),
    (5, 'Jeans', 'Apparel', 49.99, 150);CREATE TABLE products (
    product_id INT,
    product_name VARCHAR(100),
    category VARCHAR(50),
    price DECIMAL(10, 2),
    stock_quantity INT
);

INSERT INTO products (product_id, product_name, category, price, stock_quantity)
VALUES
    (1, 'Smartphone', 'Electronics', 599.99, 100),
    (2, 'Laptop', 'Electronics', 999.99, 50),
    (3, 'Headphones', 'Electronics', 99.99, 200),
    (4, 'T-shirt', 'Apparel', 19.99, 300),
    (5, 'Jeans', 'Apparel', 49.99, 150);

Give the DDl and documentation of the Database

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

npx create-replicate --model=muqtadar08/finetuned_gemma_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 muqtadar08/finetuned_gemma_sql_generator using Replicate’s API. Check out the model's schema for an overview of inputs and outputs.

const output = await replicate.run(
  "muqtadar08/finetuned_gemma_sql_generator:3b5f9fda888ca684c347536ba9fc01a7cfc60a83ae30f39c220dd072289df0ec",
  {
    input: {
      ddl_doc: "CREATE TABLE products (\n    product_id INT,\n    product_name VARCHAR(100),\n    category VARCHAR(50),\n    price DECIMAL(10, 2),\n    stock_quantity INT\n);\n\nINSERT INTO products (product_id, product_name, category, price, stock_quantity)\nVALUES\n    (1, 'Smartphone', 'Electronics', 599.99, 100),\n    (2, 'Laptop', 'Electronics', 999.99, 50),\n    (3, 'Headphones', 'Electronics', 99.99, 200),\n    (4, 'T-shirt', 'Apparel', 19.99, 300),\n    (5, 'Jeans', 'Apparel', 49.99, 150);",
      question: "find the price of laptop"
    }
  }
);

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 muqtadar08/finetuned_gemma_sql_generator using Replicate’s API. Check out the model's schema for an overview of inputs and outputs.

output = replicate.run(
    "muqtadar08/finetuned_gemma_sql_generator:3b5f9fda888ca684c347536ba9fc01a7cfc60a83ae30f39c220dd072289df0ec",
    input={
        "ddl_doc": "CREATE TABLE products (\n    product_id INT,\n    product_name VARCHAR(100),\n    category VARCHAR(50),\n    price DECIMAL(10, 2),\n    stock_quantity INT\n);\n\nINSERT INTO products (product_id, product_name, category, price, stock_quantity)\nVALUES\n    (1, 'Smartphone', 'Electronics', 599.99, 100),\n    (2, 'Laptop', 'Electronics', 999.99, 50),\n    (3, 'Headphones', 'Electronics', 99.99, 200),\n    (4, 'T-shirt', 'Apparel', 19.99, 300),\n    (5, 'Jeans', 'Apparel', 49.99, 150);",
        "question": "find the price of laptop"
    }
)
print(output)

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 muqtadar08/finetuned_gemma_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": "muqtadar08/finetuned_gemma_sql_generator:3b5f9fda888ca684c347536ba9fc01a7cfc60a83ae30f39c220dd072289df0ec",
    "input": {
      "ddl_doc": "CREATE TABLE products (\\n    product_id INT,\\n    product_name VARCHAR(100),\\n    category VARCHAR(50),\\n    price DECIMAL(10, 2),\\n    stock_quantity INT\\n);\\n\\nINSERT INTO products (product_id, product_name, category, price, stock_quantity)\\nVALUES\\n    (1, \'Smartphone\', \'Electronics\', 599.99, 100),\\n    (2, \'Laptop\', \'Electronics\', 999.99, 50),\\n    (3, \'Headphones\', \'Electronics\', 99.99, 200),\\n    (4, \'T-shirt\', \'Apparel\', 19.99, 300),\\n    (5, \'Jeans\', \'Apparel\', 49.99, 150);",
      "question": "find the price of laptop"
    }
  }' \
  https://api.replicate.com/v1/predictions

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

Output

SELECT price FROM products WHERE category = 'Electronics' AND product_name = 'Laptop';

Generated in

51.0 seconds

Tweak it Share Report View full prediction

Run time and cost

This model runs on Nvidia T4 GPU hardware. We don't yet have enough runs of this model to provide performance information.

Readme

This model doesn't have a readme.