Overview
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
Typical total price
$0.521/hour
Features and programs
Financing for AWS Marketplace purchases
Pricing
Free trial
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
Content disclaimer
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
-
During EC2 AMI launch step 3 (configure instance details) provide the following advanced detail user-data as text: #!/bin/bash /root/start-cp.sh
-
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).
-
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
Resources
Vendor resources
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.