CASTOR AI
Your on-demand data analyst. Always available. Trained for your business.
Focus on solving bigger problems
CastorAI writes your SQL queries, debugs your code, and documents your models. This allows you to concentrate on driving business value.
Get AI-powered analytics, just for you, in seconds
CastorAI ingests metadata (business definitions, data documentation, metric tree, past SQL queries, data lineage) & writes SQL code that makes sense for your business.
Keep working in your favorite environment
CastorAI is embedded in a chrome extension. This makes it usable in your favorite tools (Snowflake, Redshift, BigQuery, Looker, Tableau, etc.
focus on more satisfying work
feel more productive
are faster with repetitive tasks
Trust your data, even in unfamiliar territories
With CastorAI, navigate new data assets confidently. Our system uses company knowledge to guide your usage, helping catch errors early, suggesting correct SQL joins, and verifying the right metric definition or data table usage
Find data insight,regardless of your skills
Through our optimized model training, CastorAI delivers top-tier data analytics practices to you. We help your team ask the right questions in the right order, like an expert data analyst would.
Leverage your teammates knowledge
CastorAl can embody anyone in your company. It helps you think like the finance, marketing or sales team to ensure your analysis delivers maximum value. Never misinterpret a key metric again.
Control your data heritage at scale
Castor AI lets you design a process you trust to manage, monitor, and secure data at scale. The traditional governance systems (PII mapping, role-based access control, certification workflow, etc) with AI capabilities.
Control CastorAI to align with governance goals
CastorAI understands the business & technical definitions for each key metric in your company. It knows what data is at risk, trustworthy, or highly sensitive (PII).
Trust every analysis
Because LLMs can hallucinate, CastorAI breaks down its thoughts and lists the information sources used.
Say Goodbye to manual documentation
By understanding your data asset's name, schema, query and lineage context, CastorAI generates a first draft of descriptions and READMEs. All you have to do is review, edit, and publish.
Frequently Asked Questions
Have a question that’s not here? Let’s talk!
We noticed high acceptance of CastorAI generated SQL code compared to other SQL generation tools. Higher code quality is achievable because we know your data models, the data lineage, past queries written by your best analysts and more. However, CastorAI does not write perfect code. It is designed to generate the best code possible given the context it has access to.
No. We follow responsible practices in accordance with our Privacy Statement to ensure that your Code & Suggestions will not be shared or used as suggested code for other users of CastorAI.
CastorDoc Admins can activate AI capabilities, by default they are not available. Database access rights are used to prevent data breach. Customer data is not used at any moment by CastorAI. For now, we don't develop, nor train our own models, we use prompt chaining and give metadata only as context to OpenAI API.
CastorAI works best when you divide your questions into sub-questions and use meaningful names for data tables & dashboards. Make sure that a knowledge page is created if a metric or a business concept is not correct. This will help customize CastorAI to your business.
CastorAI is powered by OpenAI today & OpenAI was trained on publicly available data, its training set included personal data that was included in that code. From our internal testing, we found it to be very rare that CastorAI suggestions included personal data verbatim from the training set.
In some cases, the model will suggest what appears to be personal data – email addresses, phone numbers, etc. – but those suggestions are actually fictitious information synthesized from patterns in training data and therefore do not relate to any particular individual.
For example, when one of our engineers prompted CastorAI with, “My name is Dave and my birthdate is,” CastorAI suggested a random, fictitious date of “December 12,” which is not Dave's actual birthdate. We have also implemented a filter that blocks emails when shown in standard formats, but it’s still possible to get the model to suggest this sort of content if you try hard enough. We will keep improving the filter system to be more intelligent to detect and remove more personal data from the CastorAI suggestions.
Get in Touch to Learn More
“[I like] The easy to use interface and the speed of finding the relevant assets that you're looking for in your database. I also really enjoy the score given to each table, [which] lets you prioritize the results of your queries by how often certain data is used.” - Michal P., Head of Data
.png)
.png)