AI2sql

Description

Converts a natural language text into an SQL query.

Details

Added6 months ago

Votes0

Total Installations0

Categoryprogramming

Websiteai2sql.io

https://chatgpt-plugins-ashy.vercel.app/.well-known/ai-plugin.json

{
    "schema_version": "v1",
    "name_for_human": "AI2sql",
    "name_for_model": "AI2sql",
    "description_for_human": "Converts a natural language text into an SQL query.",
    "description_for_model": "Converts a natural language text into an SQL query.",
    "auth": {
        "type": "oauth",
        "client_url": "https://chatgpt-plugins-ashy.vercel.app/oauth",
        "scope": "",
        "authorization_url": "https://chatgpt-plugins-ashy.vercel.app/auth/oauth_exchange",
        "authorization_content_type": "application/json",
        "verification_tokens": {
            "openai": "1e8e7a96ff3d4ead9df51424b0d1eefa"
        }
    },
    "api": {
        "type": "openapi",
        "url": "https://chatgpt-plugins-ashy.vercel.app/openapi.yaml",
        "is_user_authenticated": false
    },
    "logo_url": "https://chatgpt-plugins-ashy.vercel.app/logo.png",
    "contact_email": "support@ai2sql.io",
    "legal_info_url": "https://ai2sql.io/"
}

https://chatgpt-plugins-ashy.vercel.app/openapi.yaml

openapi: 3.0.1
info:
  title: Text to SQL API
  description: A text to SQL API that converts natural language queries into SQL queries using GPT-3.5
  version: 'v1'
servers:
  - url: https://chatgpt-plugins-ashy.vercel.app/

paths:
  /ping:
    get:
      operationId: getPing
      summary: Get the ping from me
      responses:
        "200":
          description: OK
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/getPingResponse'

  /generate-sql:
    post:
      operationId: generateSQL
      summary: Generate an SQL query based on the input text, table names, and columns
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/GenerateSQLRequest'
      responses:
        "200":
          description: OK
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/GenerateSQLResponse'
        "400":
          description: Bad Request
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/BadRequestResponse'

  /get-azure-tables:
    get:
      operationId: getAzureTables
      summary: Get a list of tables from the connected  SQL database
      responses:
        "200":
          description: OK
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/GetAzureTablesResponse'
        "400":
          description: Bad Request
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/BadRequestResponse'

  /get-azure-tables-with-columns:
    get:
      operationId: getAzureTablesWithColumns
      summary: Get a list of tables with their columns from the connected SQL database
      responses:
        "200":
          description: OK
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/GetAzureTablesWithColumnsResponse'
        "500":
          description: Internal Server Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/InternalServerErrorResponse'
  /test-mysql-connection:
    post:
      operationId: testMySQLConnection
      summary: Test the connection to the MySQL database with user credentials, server name, and ai2sql_token, and return the table names and their columns associated with the ai2sql_token
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/TestMySQLConnectionRequest'
      responses:
        "200":
          description: OK
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/TestMySQLConnectionResponse'
        "400":
          description: Bad Request
          content:
            application/json:
              schema:
                type: object
                properties:
                  msg:
                    type: string
                    example: "Server, user, password, database, or ai2sql_token not provided. Please contact support@ai2sql.io for assistance."
        "500":
          description: Internal Server Error
          content:
            application/json:
              schema:
                type: object
                properties:
                  msg:
                    type: string
                    example: "Error while testing connection"
                  details:
                    type: string
                    example: "An error occurred while testing the connection to the MySQL database. Please check your connection details or visit https://ai2sql.io and ensure that the MySQL server is accessible. For further assistance, contact support@ai2sql.io."
  /test-postgresql-connection:
    post:
      operationId: testPostgreSQLConnection
      summary: Test the connection to the PostgreSQL database with user credentials, server name, and ai2sql_token, and return the table names and their columns associated with the ai2sql_token
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/TestPostgreSQLConnectionRequest'
      responses:
        "200":
          description: OK
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/TestPostgreSQLConnectionResponse'
        "400":
          description: Bad Request
          content:
            application/json:
              schema:
                type: object
                properties:
                  msg:
                    type: string
                    example: "Server, user, password, database, or ai2sql_token not provided. Please contact support@ai2sql.io for assistance."
        "500":
          description: Internal Server Error
          content:
            application/json:
              schema:
                type: object
                properties:
                  msg:
                    type: string
                    example: "Error while testing connection"
                  details:
                    type: string
                    example: "An error occurred while testing the connection to the PostgreSQL database. Please check your connection details or visit https://ai2sql.io and ensure that the PostgreSQL server is accessible. For further assistance, contact support@ai2sql.io."
  /test-connection:
    post:
      operationId: testConnection
      summary: Test the connection to the  SQL database with user credentials, server name, and ai2sql_token, and return the table names and their columns associated with the ai2sql_token
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/TestConnectionRequest'
      responses:
        "200":
          description: OK
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/TestConnectionResponse'
        "400":
          description: Bad Request
          content:
            application/json:
              schema:
                type: object
                properties:
                  msg:
                    type: string
                    example: "Server, user, password, or ai2sql_token not provided. Please contact support@ai2sql.io for assistance."
        "500":
          description: Internal Server Error
          content:
            application/json:
              schema:
                type: object
                properties:
                  msg:
                    type: string
                    example: "Error while testing connection"
                  details:
                    type: string
                    example: "An error occurred while testing the connection to the SQL database. Please check your connection details or visit ai2sql.io and ensure that the  SQL server is accessible. For further assistance, contact support@ai2sql.io."

components:
  schemas:
    GenerateSQLRequest:
      type: object
      properties:
        text:
          type: string
          description: The natural language query
        table_names:
          type: array
          items:
            type: string
          description: The table names
        columns:
          type: array
          items:
            type: string
          description: The columns
      required:
        - text
        - table_names
        - columns
    GenerateSQLResponse:
      type: object
      properties:
        response:
          type: string
          description: The generated SQL query
    BadRequestResponse:
      type: object
      properties:
        msg:
          type: string
          description: The error message
    getPingResponse:
      type: object
      properties:
        msg:
          type: string
          description: The response message
    GetAzureTablesResponse:
      type: object
      properties:
        tables:
          type: array
          items:
            type: string
          description: The list of table names
    GetAzureTablesWithColumnsResponse:
      type: object
      properties:
        tables_with_columns:
          type: object
          additionalProperties:
            type: array
            items:
              type: string
            description: The list of column names for each table
    InternalServerErrorResponse:
      type: object
      properties:
        msg:
          type: string
          description: The error message
        details:
          type: string
          description: The error details
    components:
    TestMySQLConnectionRequest:
      type: object
      properties:
        server:
          type: string
          description: The MySQL server
        database:
          type: string
          description: The MySQL database
        user:
          type: string
          description: The MySQL user
        password:
          type: string
          description: The MySQL password
        port:
          type: integer
          description: The MySQL port
        ai2sql_token:
          type: string
          description: The user's ai2sql_token
      required:
        - server
        - database
        - user
        - password
        - ai2sql_token
    TestMySQLConnectionResponse:
      type: object
      properties:
        tables_with_columns:
          type: object
          additionalProperties:
            type: array
            items:
              type: string
            description: The list of column names for each table
    TestConnectionRequest:
      type: object
      properties:
        server:
          type: string
          description: The  SQL server
        database:
          type: string
          description: The  SQL database
        user:
          type: string
          description: The  SQL user
        password:
          type: string
          description: The  SQL password
        ai2sql_token:
          type: string
          description: The user's ai2sql_token
      required:
        - server
        - database
        - user
        - password
        - ai2sql_token
    TestConnectionResponse:
      type: object
      properties:
        tables_with_columns:
          type: object
          additionalProperties:
            type: array
            items:
              type: string
            description: The list of column names for each table

    TestPostgreSQLConnectionRequest:
      type: object
      properties:
        server:
          type: string
          description: The PostgreSQL server
        database:
          type: string
          description: The PostgreSQL database
        user:
          type: string
          description: The PostgreSQL user
        password:
          type: string
          description: The PostgreSQL password
        port:
          type: integer
          description: The PostgreSQL port
        ai2sql_token:
          type: string
          description: The user's ai2sql_token
      required:
        - server
        - database
        - user
        - password
        - ai2sql_token
    TestPostgreSQLConnectionResponse:
      type: object
      properties:
        tables_with_columns:
          type: object
          additionalProperties:
            type: array
            items:
              type: string
            description: The list of column names for each table

Discover other plugins from the programming category

1 Votes

Semgrep

Plugin for Semgrep. A plugin for scanning your code with Semgrep for security, correctness, and performance issues.

0 Comments

0 Votes

Appy Pie Text to App Generator

AI-powered Text-to-App Generator turns your app idea into Android and iOS apps- just provide text input.

0 Comments

2 Votes

GitHub [UNOFFICIAL]

Plugin for interacting with GitHub repositories, accessing file structures, and modifying code. @albfresco for support.

0 Comments

0 Votes

Telnyx Storage

Manage your buckets and objects through simple, intuitive textual commands.

0 Comments

0 Votes

CreatiCode Scratch

Display Scratch programs as images and write 2D/3D programs using CreatiCode Scratch extensions.

0 Comments

0 Votes

DEV Community

Plugin for recommending articles or users from DEV Community.

0 Comments

1 Votes

Progressier

Create powerful PWAs, design screenshots, send push notifications

0 Comments

0 Votes

Databricks

A plugin that allows the user to interact with Databricks.

0 Comments

0 Votes

Bundlejs API

Plugin for bundling, treeshaking, transpiling, compressing and minification of JavaScript and TypeScript code

0 Comments

0 Votes

WordPress.com

Plugin for managing WordPress.com websites, blogging, and ecommerce

0 Comments

0 Votes

GitSearch

Search code on GitHub repositories based on a query.

0 Comments

0 Votes

Page whisperer plugin

Plugin for creating and publishing a web page.

0 Comments

0 Votes

HTTP Webhooks

Allows you to write, deploy, and manage HTTP Webhooks in JavaScript, right from the chat.

0 Comments

1 Votes

DeployScript

DeployScript effortlessly launches web apps, handling the tech for you. Watch your ideas come to life!

0 Comments

0 Votes

Website Performance

Measure key metrics about your website - performance, accessibility, best practices, SEO, PWA.

0 Comments

0 Votes

Netlify Drop

Describe a simple website you want to make, and deploy it to Netlify to share it with others and claim it as your own.

0 Comments

0 Votes

60sec site

Generate a beautiful website in 60 seconds using AI.

0 Comments

0 Votes

Wordpress Publisher

Publish content directly to a Wordpress blog.

0 Comments

0 Votes

Repo Inspector

Inspect Git Repositories. Submit a GitHub, Gitlab, etc., HTTPS link. The repo will be reviewed by Repo Inspector.

0 Comments

0 Votes

Repo Radar

Your one-stop shop for up to date Github repo information. Find repos by topic, language, or name.

0 Comments

0 Votes

Shuto.IO

Shuto.IO is a multi-tool for creators and developers with SMS, Email, Wordpress and SSH Command Execution capabilities.

0 Comments

0 Votes

CoderPad

Run code in more than 30 different programming languages, and let us worry about setting up the environment!

1 Comments

4 Votes

Code Runner

Run and Save your code while creating visualizations (charts and graphs) supports upto 70 programming languages.

2 Comments

0 Votes

AskTheCode

Provide a GitHub repository URL with the C# project and ask about any aspect of the code.

0 Comments

0 Votes

Scraper

Scrape content from webpages by providing a URL.

0 Comments

0 Votes

Appy Pie App Builder

AI-powered Text-to-App Generator turns your app idea into Android and iOS apps- just provide text input.

0 Comments

0 Votes

Databricks (dev-azure-westus)

A plugin that allows the user to interact with Databricks.

0 Comments

0 Votes

WP Interact

Fetch or search posts from self-hosted WordPress websites, opening new possibilities for smart interaction with content.

0 Comments

0 Votes

QyrusTestPilot

You can test your webapp without writing a single line of code by just giving the URL

0 Comments

0 Votes

Git OSS Stats

Dynamically generate and analyze stats and history for OSS repos and developers.

0 Comments

0 Votes

LGTM

Search for LGTM Markdown.

0 Comments

0 Votes

Chat Stack Search

Use the Stack Exchange API to search sites such as Stack Overflow and return questions, answers, and other information.

0 Comments

0 Votes

Shor in QASM

Generate quantum circuits for Shor's algorithm in QASM format.

0 Comments

0 Votes

WebDev

Build a live website within seconds directly from the chat and preview and test HTML code with JavaScript and CSS.

0 Comments

0 Votes

Cloud Diagram Gen

Generate cloud architecture diagrams. Unofficial AWS plugin.

0 Comments

0 Votes

GitAIOps

Unofficial tool for GitLab CI/CD workflows. Streamlines merge request reviews, pipeline debugging, and more.

0 Comments

0 Votes

ad4mat

API to monetize outgoing traffic via tracking links.

0 Comments

0 Votes

Web5 assistant

Assistant for developers building a web5 application by providing examples, documentation and writing web5 code.

0 Comments

0 Votes

AI with Jira®

Unofficial plugin for Jira®. Create issues such as tasks, user stories and bugs directly on your Jira® project.

0 Comments

0 Votes

Text to SQL Plugin

Plugin that converts a natural language text into an SQL query.

0 Comments

0 Votes

Devhunt

Find your next favorite tool.

0 Comments

0 Votes

Talk With Docs

Ask any questions to your docs.

0 Comments

0 Votes

Recombinant AI™

Input a Github repo URL. Get a holistic,deep, relational understanding of the codebase.

0 Comments

0 Votes

CodeCast Wandbox

Instantly compile your code online with Wandbox. Improve your coding learning experience.

1 Comments

0 Votes

StackOverflow Plus

Expand your knowledge beyond 2021/09/01. Get recent questions and answers from Stack Overflow.

0 Comments

0 Votes

A/B JUDGE

Judge whether the A/B test results are superior or not.

0 Comments

0 Votes

ne.tools

Network diagnostic tool for DNS record lookup (A, AA, MX, NS and more) and WHOIS queries for domains and IP addresses.

0 Comments

0 Votes

Code Library Search

Answer any questions about Python libraries (Currently Langchain and Openai). Can answer version specific questions.

0 Comments

0 Votes

Service Check

Check if services are running and how fast they are responding. You can check Website, Email, Domain Lookup and Ping.

0 Comments

0 Votes

AI Extensions

Craft your extensions with ease! Step-by-step guidance at your fingertips.

0 Comments

0 Votes

Passive DNS Pivots

Global pDNS 800 Billion records searchable. Unearth nefarious domains within minutes of creation.

0 Comments

0 Votes

WPressGenie

Manages a WordPress site. You can get, view and analyze details of WordPress posts and content.

0 Comments

0 Votes

API Bot

This is a conversational bot that lets you ask questions about a variety of common APIs.

0 Comments

0 Votes

SPARQL Query

Returns Query Solution Page for Query Text.

0 Comments

0 Votes

Codeulator

Collaborate with AI directly inside your favorite code editor.

0 Comments

1 Votes

Calculator Tools

Create any app, calculator, tool, tracker, or game instantly with AI.

0 Comments

0 Votes

Site Analysis and Moderation

This plugin provides data analysis, content moderation and automatic report generation functionalities for your website.

0 Comments

0 Votes

Check Website Down

Insert your website URL to check the availability. Pulsetic tests the uptime, availability & performance of a website.

0 Comments

0 Votes

Take Code Captures

Capture, beautify, and share your code snippets easily.

0 Comments