Listing Thumbnail

    English to SQL via C-Phrase

     Info
    Free Trial
    AWS Free Tier
    Let non-technical users quickly and easily access your SQL database
    Listing Thumbnail

    English to SQL via C-Phrase

     Info

    Overview

    Play video

    C-Phrase is a front-end for natural language querying of SQL-based databases. So instead of writing SQL or filling out forms, users just type (or click build) their questions and commands in plain English. C-Phrase uses AI to find all the meaningful interpretations of the user's input. If there are multiple possible interpretations or if the user is requesting a data modification, then C-Phrase paraphrases interpretations back to the user in English for selection or confirmation. This gives users complete control over what SQL gets applied.

    C-Phrase promotes data democratization: Non-technical users can 'google' the database using precise, often complex conditions. Results are specific values, lists, tables or charts. Users can export these results to CSV files in a single click for use in other tools. Administrators can easily set up example questions, extended lexicons and reports to empower even the most non-technical users.

    C-Phrase raises data quality: Many companies must manually fix data in complex SQL databases to deliver high quality products and services. Often this is a painstaking process involving standardization of data values, removal of outliers and one-off corrections. Companies might also wish to insert answers from ChatGPT into the given database. C-Phrase can give users the ability to input, update or delete data via natural language commands. This results in the rapid creation of SQL scripts that can be integrated into data deployment pipelines. C-Phrase's data modification capability can be enabled on a table by table basis and is naturally off by default.

    C-Phrase reduces administration costs: Users would like to ask a series of unanticipated questions over various levels of granularity to tease out subtle trends in the data. Busy database administrators prefer to give users self-service capabilities rather than constantly being tasked to write special dashboards, data entry screens or custom SQL. C-Phrase provides exactly this capability.

    Each new release of C-Phrase comes with additional example configurations and databases. Launching C-Phrase will give you immediate access to these examples which you are free to adapt to your own purposes. The number of users and natural language interfaces per virtual machine is limited only by the size of the virtual machine you launch. It is quite likely all your needs will be met with a single small virtual machine.

    Highlights

    • Natural language to SQL select, insert, update and delete queries: C-Phrase can map natural language to OLTP and OLAP queries expressing regular conditions, set conditions, date and time conditions, superlatives, negations, universal and existential quantification, cardinality conditions, etc. C-Phrase also integrates well with transaction processing and database check-pointing via explicit SQL logging and the ability to start, abort or commit transactions.
    • Flexible cloud-based administration: Log into the Admin Interface, connect to your remote database and automatically build an initial interface in under five minutes. Use editing tools to customize and refine an interface with synonyms, regular expressions, ellipsis, additional views and reports. Launch a natural language interface and invite your users to access it. Finally you can explore and manage XML-based logs of user sessions to pinpoint where to improve your interface.
    • Open formats and APIs for interoperability: All configuration for C-Phrase natural language interfaces is represented in a single XML file in a completely documented and open format. In addition, live natural language interfaces can be accessed via REST calls. This lets you embed natural language interfaces across many applications including those that use voice recognition. Finally C-Phrase can easily be secured with certificates to allow for HTTPS access.

    Details

    Delivery method

    Delivery option
    64-bit (x86) Amazon Machine Image (AMI)

    Latest version

    Operating system
    Debian 12

    Typical total price

    This estimate is based on use of the seller's recommended configuration (t3.small) in the US East (N. Virginia) Region. View pricing details

    $0.521/hour

    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

    Free trial

    Try this product at no cost for 7 days according to the free trial terms set by the vendor. Usage-based pricing is in effect for usage beyond the free trial terms. Your free trial gets automatically converted to a paid subscription when the trial ends, but may be canceled any time before that.

    English to SQL via C-Phrase

     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 (18)

     Info
    Instance type
    Product cost/hour
    EC2 cost/hour
    Total/hour
    t2.micro
    AWS Free Tier
    $0.25
    $0.012
    $0.262
    t2.small
    $0.50
    $0.023
    $0.523
    t2.medium
    $1.00
    $0.046
    $1.046
    t2.large
    $2.00
    $0.093
    $2.093
    t2.xlarge
    $4.00
    $0.186
    $4.186
    t2.2xlarge
    $8.00
    $0.371
    $8.371
    t3.micro
    AWS Free Tier
    $0.25
    $0.01
    $0.26
    t3.small
    Recommended
    $0.50
    $0.021
    $0.521
    t3.medium
    $1.00
    $0.042
    $1.042
    t3.large
    $2.00
    $0.083
    $2.083

    Additional AWS infrastructure costs

    Type
    Cost
    EBS General Purpose SSD (gp3) volumes
    $0.08/per GB/month of provisioned storage

    Vendor refund policy

    We do not currently support refunds, but you can cancel at any time.

    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

    64-bit (x86) Amazon Machine Image (AMI)

    Amazon Machine Image (AMI)

    An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.

    Version release notes

    A new C-Phrase update: 1: enhanced explorer; 2: dynamic corpus selection from NLIs; 3: better support for back-ups;

    Additional details

    Usage instructions

    The full documentation of C-Phrase is available at: https://c-phrase.com/documentation 

    1. During EC2 AMI launch step 3 (configure instance details) provide the following advanced detail user-data as text: #!/bin/bash /root/start-cp.sh

    2. In your security policies, allow ingress on port 9999 as well as a range of ports that you will run NLIs on (for example ports 8000-9998).

    3. Visit http://<IP-of-EC2-Instance>:9999 user name:admin password:<id-of-your-EC2-Instance>

    For more details and instructions to change your user name/password visit https://c-phrase.com/documentation/on-aws.html 

    Support

    Vendor support

    We are very interested to learn how you are using C-Phrase, thus we offer several hours of free support or consultation for our new customers. Please reach out to us at contact@c-phrase.com . We can also enter into support contracts to help customers integrate, author and extend C-Phrase to meet their specific needs. Finally we are always open to negotiate private offers and can offer C-Phrase at drastically reduced or free prices for academic and other non-commercial use.

    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
    |
    3 external reviews
    External reviews are sourced from G2  and are not included in the star rating for this product.
    Manish S.

    Good For Data Entry And Professional Reporting Making.

    Reviewed on Jun 17, 2022
    Review provided by G2
    What do you like best about the product?
    The best thing about this c-phrase is it offers a REST-based end-point that acknowledges Natural language questions and returns SQL, SQL + Answers. You can also store voice data. What I like the most about this is you can make your own custom plan, the starting price is 100$. This service is generally used to do data entry, report making, and data cleaning. Customer support is free for basic support.
    What do you dislike about the product?
    From my point of view, I feel the Dashboard of this software is a little bit messy. Data exporting is slow, I feel lag whenever I try to export data. overall it is good not the best.
    What problems is the product solving and how is that benefiting you?
    I can make a report in natural language which save lots of time and this software support amazon aurora which is good for us because 70% of work was done in Amazon Aurora.
    Recommendations to others considering the product:
    This is not the best but you can use this for the short term it is recommended use once.
    Binaya M.

    Best tool to translate multilingual website

    Reviewed on Jun 15, 2022
    Review provided by G2
    What do you like best about the product?
    As a digital marketer, I have managed multiple websites from different countries and this tool makes it really easy to translate different languages worldwide. It is straightforward to use and configure.
    What do you dislike about the product?
    The user interface can be improved more but otherwise, this tool is almost perfect for me. This tool is not for large projects but for small and medium projects it works flawlessly.
    What problems is the product solving and how is that benefiting you?
    This tool helps convert the content from one language to another and is straightforward to use. If you don't want to hire a different content writer for each content then this tool can be very useful.
    Nic B.

    There's a lesson in everything - This lesson is to use this product!

    Reviewed on Jun 14, 2022
    Review provided by G2
    What do you like best about the product?
    Automatically fills out all forms without having to waste time or manpower completing simple tasks.
    What do you dislike about the product?
    No problems on my end! I usually have ways to suggest improvement but in this case, we're good to go!
    What problems is the product solving and how is that benefiting you?
    Curating data is always a tricky bit, C-Phrase works to give a user-friendly data management experience.
    View all reviews