How datakitpage/datakit works
DataKit is a browser-based data analysis studio: users import local or remote datasets, then inspect, query, analyze with AI, or work in Python notebooks. The README describes processing as local to the browser unless users explicitly connect cloud services. The graph includes the documented analysis capabilities and sampled backend account, workspace, credit, and PostgreSQL-proxy services. Frontend internals were mostly not sampled, so their feature relationships are documented at the capability level rather than inferred as specific calls.
Main entry points: App.tsx Studio shell · auth.service.ts Authentication · auth.controller.ts Auth endpoints · subscriptions.service.ts Plans and billing
Components 26
Studio experience
- Studio shell
frontend/src/App.tsx
Data workflows
- Dataset import
frontend/src/hooks/useDirectFileImport.ts - Remote connectors
frontend/src/hooks/remote - Local data engine
frontend/src/lib/duckdb/ingestion
Analysis tools
- Grid and inspection
frontend/src/components/data-grid - Quality analysis
frontend/src/lib/duckdb/inspector/inspector.ts - SQL workspace
frontend/src/hooks/query/useQueryExecution.ts - DuckDB queries
frontend/src/lib/duckdb/query.ts - AI assistant
frontend/src/lib/ai/aiService.ts - Python notebooks
frontend/src/lib/python/executor.ts
Identity and teams
- Auth endpoints
backend/api/src/auth/auth.controller.ts - Authentication
backend/api/src/auth/auth.service.ts - User accounts
backend/api/src/users/entities/user.entity.ts - User operations
backend/api/src/users/users.service.ts - Workspace records
backend/api/src/workspaces/entities/workspace.entity.ts - Team membership
backend/api/src/workspaces/entities/workspace-member.entity.ts - Workspace operations
backend/api/src/workspaces/workspaces.service.ts
Platform services
- Application API
backend/api/src/main.ts - Plans and billing
backend/api/src/subscriptions/subscriptions.service.ts - Subscription records
backend/api/src/subscriptions/entities/subscription.entity.ts - Credit accounting
backend/api/src/credits/credits.service.ts - Usage records
backend/api/src/credits/entities/credit-usage.entity.ts - Postgres endpoints
backend/api/src/postgres-proxy/postgres-proxy.controller.ts - Postgres proxy
backend/api/src/postgres-proxy/postgres-proxy.service.ts
Other components
- Data analyst
- Connected PostgreSQL
Connections 22
- Data analyst → Studio shell: uses
README.md - Studio shell → Dataset import: starts import
README.md - Dataset import → Local data engine: loads locally
README.md - Remote connectors → Local data engine: imports data
README.md - Studio shell → Grid and inspection: opens preview
README.md - Grid and inspection → Quality analysis: analyzes data
README.md - Studio shell → SQL workspace: opens SQL
README.md - SQL workspace → DuckDB queries: runs SQL
README.md - Studio shell → AI assistant: asks questions
README.md - Studio shell → Python notebooks: opens notebooks
README.md - Data analyst → Auth endpoints: signs in
backend/api/src/auth/auth.controller.ts - Auth endpoints → Authentication: handles auth
backend/api/src/auth/auth.controller.ts - Authentication → User operations: looks up users
backend/api/src/auth/auth.service.ts - Authentication → Plans and billing: creates plan
backend/api/src/auth/auth.service.ts - Authentication → Workspace operations: creates workspace
backend/api/src/auth/auth.service.ts - Auth endpoints → User accounts: returns profile
backend/api/src/auth/auth.controller.ts - Workspace operations → Team membership: manages members
- Plans and billing → Subscription records: persists plans
- Credit accounting → Usage records: records usage
backend/api/src/credits/credits.service.ts - Credit accounting → Plans and billing: checks allowance
backend/api/src/credits/credits.service.ts - Postgres endpoints → Postgres proxy: routes requests
backend/api/src/postgres-proxy/postgres-proxy.controller.ts - Postgres proxy → Connected PostgreSQL: queries database