Listing Thumbnail

    Text to SQL using LLM

     Info
    Sold by: Mphasis 
    Deployed on AWS
    It is a Generative AI (LLM) based offering which can generate SQL query given a table schema and meta data and validate it through a dry run

    Overview

    The solution uses Generative AI to generate complex SQL queries leveraging bedrock claude(LLM) modelgiven a question prompt. The solution also validates the generated queries by testing them with sample data to ensure a smooth run without any errors. The solution requires only two input files containing questions in the English language and a data schema with metadata in JSON format. The output file contains the SQL queries perfectly ready to run. If the asked question is too complex the GenAI-based solution also suggests changes that get generated along with the query.
    The offering requires an AWS bedrock anthropic Claude Instant model subscription.

    Highlights

    • The solution can be useful to analyze the multi-tabular data without giving the actual data to the LLM. It generates complex SQL queries given appropriate prompts on one table schema at a time and up to 4 questions in a single inference. It also validates the queries for a smooth run and returns the error or warning if any.
    • It can be used for data analysis tasks, to extract information from tabular data, and does not require any expertise in SQL or GenAI. The users required only the AWS credentials of an account that has an LLM (bedrock anthropic-claude-instant-v1) model subscription.
    • Mphasis DeepInsights is a cloud-based cognitive computing platform that offers data extraction & predictive analytics capabilities. Need customized Machine Learning and Deep Learning solutions? Get in touch!

    Details

    Delivery method

    Latest version

    Deployed on AWS

    Unlock automation with AI agent solutions

    Fast-track AI initiatives with agents, tools, and solutions from AWS Partners.
    AI Agents

    Features and programs

    Financing for AWS Marketplace purchases

    AWS Marketplace now accepts line of credit payments through the PNC Vendor Finance program. This program is available to select AWS customers in the US, excluding NV, NC, ND, TN, & VT.
    Financing for AWS Marketplace purchases

    Pricing

    Text to SQL using LLM

     Info
    Pricing is based on actual usage, with charges varying according to how much you consume. Subscriptions have no end date and may be canceled any time.
    Additional AWS infrastructure costs may apply. Use the AWS Pricing Calculator  to estimate your infrastructure costs.

    Usage costs (3)

     Info
    Dimension
    Description
    Cost
    ml.m5.large Inference (Batch)
    Recommended
    Model inference on the ml.m5.large instance type, batch mode
    $5.00/host/hour
    ml.m4.xlarge Inference (Batch)
    Model inference on the ml.m4.xlarge instance type, batch mode
    $5.00/host/hour
    inference.count.m.i.c Inference Pricing
    inference.count.m.i.c Inference Pricing
    $3.00/request

    Vendor refund policy

    Currently, we do not support refunds, but you can cancel your subscription to the service at any time.

    How can we make this page better?

    We'd like to hear your feedback and ideas on how to improve this page.
    We'd like to hear your feedback and ideas on how to improve this page.

    Legal

    Vendor terms and conditions

    Upon subscribing to this product, you must acknowledge and agree to the terms and conditions outlined in the vendor's End User License Agreement (EULA) .

    Content disclaimer

    Vendors are responsible for their product descriptions and other product content. AWS does not warrant that vendors' product descriptions or other product content are accurate, complete, reliable, current, or error-free.

    Usage information

     Info

    Delivery details

    Amazon SageMaker model

    An Amazon SageMaker model package is a pre-trained machine learning model ready to use without additional training. Use the model package to create a model on Amazon SageMaker for real-time inference or batch processing. Amazon SageMaker is a fully managed platform for building, training, and deploying machine learning models at scale.

    Deploy the model on Amazon SageMaker AI using the following options:
    Deploy the model as an API endpoint for your applications. When you send data to the endpoint, SageMaker processes it and returns results by API response. The endpoint runs continuously until you delete it. You're billed for software and SageMaker infrastructure costs while the endpoint runs. AWS Marketplace models don't support Amazon SageMaker Asynchronous Inference. For more information, see Deploy models for real-time inference  .
    Deploy the model to process batches of data stored in Amazon Simple Storage Service (Amazon S3). SageMaker runs the job, processes your data, and returns results to Amazon S3. When complete, SageMaker stops the model. You're billed for software and SageMaker infrastructure costs only during the batch job. Duration depends on your model, instance type, and dataset size. AWS Marketplace models don't support Amazon SageMaker Asynchronous Inference. For more information, see Batch transform for inference with Amazon SageMaker AI  .
    Version release notes

    first version

    Additional details

    Inputs

    Summary

    Usage Methodology for the algorithm:

    1. The input must be 'Input.zip' file.
    2. The zip file should contain three files 'credentials', 'input-question' and 'input' in .json format.
    3. The credentials file includes the aws access keys with region of the account which has a subscription of anthripic Claude Instant bedrock model.
    4. Name of the folder inside the zip file should be “input” which is case-sensitive
    5. check the instructions and sample endpoint in the sample jupyter file provided.
    Limitations for input type
    cant not input more than 4 questions at time for inferencing.
    Input MIME type
    application/zip, text/plain
    https://github.com/Mphasis-ML-Marketplace/Text-to-SQL-using-LLM/blob/main/input.zip
    https://github.com/Mphasis-ML-Marketplace/Text-to-SQL-using-LLM/blob/main/input.zip

    Support

    Vendor support

    For any assistance reach out to us at:

    AWS infrastructure support

    AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.

    Similar products

    Customer reviews

    Ratings and reviews

     Info
    0 ratings
    5 star
    4 star
    3 star
    2 star
    1 star
    0%
    0%
    0%
    0%
    0%
    0 AWS reviews
    No customer reviews yet
    Be the first to review this product . We've partnered with PeerSpot to gather customer feedback. You can share your experience by writing or recording a review, or scheduling a call with a PeerSpot analyst.