How It Works
A powerful on-premise AI data analysis solution that connects directly to your databases
Connect to Your Databases
Ceneca securely connects to your databases without requiring data to leave your environment. Setup is simple and straightforward, with support for MongoDB, PostgreSQL, Qdrant, and more.
$ ceneca connect --db mongodb://localhost:27017/mydb
Connected to MongoDB database.
$ ceneca connect --db postgresql://user:pass@localhost:5432/mydb
Connected to PostgreSQL database.
Query With Natural Language
Simply ask questions in plain English, and Ceneca translates them into optimized database queries. No need to write complex SQL or NoSQL queries - just ask what you want to know.
$ ceneca query "What were our top selling products last month?"
Generating SQL...
SELECT product_name, SUM(quantity) as total_sold
FROM sales
WHERE sale_date >= '2023-04-01' AND sale_date <= '2023-04-30'
GROUP BY product_name
ORDER BY total_sold DESC
LIMIT 10;
Query executed successfully. 10 rows returned.
$ ceneca query "Show me customer retention trends by region"
Analysis complete. Displaying results...
$ ceneca query "Identify transactions with unusual patterns"
Analysis complete. 5 suspicious transactions identified.
Get AI-Powered Insights
Ceneca doesn't just return raw data - it analyzes the results and provides meaningful insights and visualizations to help you understand your data better.
$ ceneca analyze "What are the key trends in our customer data?"
Processing customer data...
Analysis complete. 3 key trends identified:
1. 67% of high-value customers are located in urban areas
2. Average customer retention has improved by 12% since last quarter
3. Product category "Electronics" shows strongest growth at 23% YoY
$ ceneca visualize "Show me sales performance across all regions"
Visualization generated. Opening chart...
$ ceneca recommend "How can we improve conversion rates?"
Generating recommendations based on data patterns...
Enterprise-Grade Security
All processing happens within your security perimeter. Your data never leaves your environment, ensuring compliance with data privacy regulations and internal security policies.
$ ceneca config set --security-level=high
Security level set to high. All data will be processed locally.
$ ceneca logs --security-events
2023-05-15 09:12:33 - Auth: User authentication successful
2023-05-15 10:23:45 - Access: Database connection established
2023-05-15 11:45:12 - Security: All queries executed within secure perimeter
$ ceneca security check
Security check complete. All systems compliant with enterprise security standards.
Simple Command Line Interface
Access the power of Ceneca through a simple CLI
Connect to your MongoDB database
ceneca connect --db mongodb://localhost:27017/mydb
Query your data with natural language
ceneca query "Show me sales by region for the last quarter"
Get AI-powered insights from your data
ceneca analyze "What are the key trends in our customer data?"
$ ceneca connect --db mongodb://localhost:27017/mydb
Successfully connected to your MongoDB database!
Connection details:
- Host: localhost:27017
- Database: mydb
- Status: Connected
$ ceneca list-collections
Available collections:
- users (documents: 1,245)
- products (documents: 532)
- orders (documents: 8,721)
- analytics (documents: 15,320)