Welcome to Q — DataLens
Q — Datalens is a unified, serverless client-side data platform. It allows developers and analysts to inspect, query, visualize, and validate data directly in the browser without backend dependencies.
Architecture & Privacy
Privacy First
Data never leaves your device. DataLens uses standard HTML5 File APIs to read files
into memory. Persistence is handled via LocalStorage and
IndexedDB within your browser sandbox.
Zero Latency
Because there is no network round-trip for processing, operations like filtering, sorting, and charting happen instantly, limited only by your device's RAM.
Data Explorer
The central hub for viewing raw data. Supports .CSV, .XLSX, and
.JSON.
Key Features
- Smart Schema Detection: Automatically identifies column types (String, Number, Date, Boolean) upon upload.
- Global Search: Real-time filtering across all visible columns using the search bar.
- Visual Columns: Toggle column visibility to focus on relevant data points.
- Export: Download filtered views as CSV, Excel, or JSON.
Computation Engine
A statistical profiling tool designed to understand the shape and quality of your dataset.
Numeric Stats
Calculates Sum, Mean, Median, Std Dev, Variance, Min, and Max for all numerical columns.
Text Stats
Analyzes string lengths, identifies most frequent values (Mode), and counts empty/null strings.
Date Analysis
Parses dates to find Earliest, Latest, and span (duration) of time-series data.
No-Query Workspace
Perform complex SQL-like operations using a drag-and-drop interface. No coding required.
| Operation | Description |
|---|---|
| Group By | Aggregate rows based on categorical columns (e.g., Group By Region).
|
| Aggregation | Apply functions: SUM, AVG, COUNT,
MAX, MIN. |
| Filtering | Apply pre-aggregation filters (e.g., Price > 100). |
Schema Designer
A visual Entity-Relationship (ER) diagram builder. Design database schemas and export SQL.
Capabilities
- Drag & Drop: Create tables and move them around the canvas.
- Templates: One-click load for common schemas (E-commerce, CMS, User System).
- Relationships: Visually link tables to define Foreign Keys (One-to-Many).
- SQL Export: Auto-generates
CREATE TABLEscripts for PostgreSQL, MySQL, and SQLite.
Data Validator
Ensures data quality through rule-based validation and dataset comparison.
age >= 18 or email != null).
The tool scans the dataset and flags rows that violate these rules.
API Studio
A professional environment for testing REST APIs (GET, POST, PUT, DELETE).
- History: Keeps a session-based log of all requests.
- Analytics: Parse JSON arrays from responses and visualize fields directly
(e.g., charting
pricesfrom a product API). - Preview: Formats JSON responses with syntax highlighting.
Visualizer
Transform datasets into presentation-ready charts using the Chart.js engine.
Support & Collaboration
Need help with Q — DataLens or looking to collaborate on data-centric projects?