Dashboard / Repos / Datachat

Datachat

D 52 completed
Other
cli / python · small
358
Files
50,389
LOC
5
Frameworks
10
Languages
OverviewFiles & MetricsGit ActivityCall GraphSecurityReports

Pipeline State

completed
Run ID
#1546044
Phase
done
Progress
0%
Started
2026-04-16 23:44:42
Finished
2026-04-16 23:44:42
LLM tokens
0

Pipeline Metadata

Stage
Cataloged
Decision
proceed
Novelty
76.87
Framework unique
—
Isolation
—
Last stage change
2026-05-10 03:34:40
Deduplication group #1938286
Member of a group with 1 similar repo(s) — this repo is canonical view group →
About: code-quality intelligence by Repobility · https://repobility.com

🧪 Code Distillation

Browse all specs →
Function bodies →
1,453
Real LLM specs →
0
0.0% coverage
All specs →
0
LLM insights →
0

AI Prompt

Create a self-hosted, text-to-SQL chat interface using Python. I need the system to allow users to ask questions in natural language and receive the generated SQL queries, results, and charts. The setup should support connecting to PostgreSQL and ideally handle multiple databases via a flag. Please ensure the architecture supports schema exploration via a sidebar and uses Gemini for the underlying logic. The project structure should be ready to run using `python start.py`.
python flask fastapi cli sql postgresql chat gemini web-app
Generated by gemma4:latest

Catalog Information

Create a self-hosted, text-to-SQL chat interface using Python. I need the system to allow users to ask questions in natural language and receive the generated SQL queries, results, and charts. The setup should support connecting to PostgreSQL and ideally handle multiple databases via a flag. Please ensure the architecture supports schema exploration via a sidebar and uses Gemini for the underlying logic. The project structure should be ready to run using python start.py.

Tags

python flask fastapi cli sql postgresql chat gemini web-app

Quality Score

D
51.6/100
Structure
66
Code Quality
54
Documentation
68
Testing
40
Practices
40
Security
27
Dependencies
90

Strengths

  • Code linting configured (ruff (possible))
  • Consistent naming conventions (snake_case)
  • Properly licensed project

Weaknesses

  • No CI/CD configuration — manual testing and deployment
  • Potential hardcoded secrets in 3 files
  • 6994 duplicate lines detected — consider DRY refactoring
  • 11 'god files' with >500 LOC need decomposition

Recommendations

  • Set up CI/CD (GitHub Actions recommended) to automate testing and deployment
  • Move hardcoded secrets to environment variables or a secrets manager

Languages

python
68.2%
typescript
20.6%
json
6.8%
markdown
2.3%
html
1.0%
ini
0.4%
toml
0.4%
yaml
0.3%
javascript
0.1%
text
0.0%

Frameworks

Flask FastAPI pytest Vite SQLAlchemy

Symbols

method1,198
variable876
class340
function154
constant93
property47
interface19
type_alias11

API Endpoints (41)

Same analyzer free for public repos: https://repobility.com
MethodPathHandlerFramework
Repobility — same analyzer, your code, free for public repos · /scan/
GET/indexFastAPI/Flask
GET/helloPython
GET/indexFastAPI/Flask
GET/api/schemaget_schemaFastAPI/Flask
GET/api/v0/create_functioncreate_functionPython
POST/api/v0/delete_functiondelete_functionPython
GET/api/v0/download_csvdownload_csvPython
POST/api/v0/fix_sqlfix_sqlPython
GET/api/v0/generate_followup_questionsgenerate_followup_questionsPython
GET/api/v0/generate_plotly_figuregenerate_plotly_figurePython
GET/api/v0/generate_questionsgenerate_questionsPython
GET/api/v0/generate_rewritten_questiongenerate_rewritten_questionPython
GET/api/v0/generate_sqlgenerate_sqlPython
GET/api/v0/generate_summarygenerate_summaryPython
GET/api/v0/get_all_functionsget_all_functionsPython
GET/api/v0/get_configget_configPython
GET/api/v0/get_functionget_functionPython
GET/api/v0/get_question_historyget_question_historyPython
GET/api/v0/get_training_dataget_training_dataPython
GET/api/v0/load_questionload_questionPython
GET/api/v0/logsock_logPython
GET/api/v0/<path:catch_all>catch_allPython
POST/api/v0/remove_training_dataremove_training_dataPython
GET/api/v0/run_sqlrun_sqlPython
POST/api/v0/trainadd_training_dataPython
POST/api/v0/update_functionupdate_functionPython
POST/api/v0/update_sqlupdate_sqlPython
POST/api/vanna/v2/chat_pollchat_pollFastAPI/Flask
POST/api/vanna/v2/chat_pollchat_pollFastAPI/Flask
POST/api/vanna/v2/chat_ssechat_sseFastAPI/Flask
POST/api/vanna/v2/chat_ssechat_sseFastAPI/Flask
GET/api/vanna/v2/chat_websocketchat_websocketFastAPI/Flask
WEBSOCKET/api/vanna/v2/chat_websocketchat_websocketFastAPI/Flask
GET/assets/<path:filename>proxy_assetsPython
GET/auth/callbackcallbackPython
POST/auth/loginloginPython
GET/auth/logoutlogoutPython
GET/healthhealth_checkFastAPI/Flask
GET/healthhealth_checkFastAPI/Flask
GET/<path:path>helloPython
GET/vanna.svgproxy_vanna_svgPython

Quality Timeline

1 quality score recorded.

View File Metrics
Powered by Repobility — scan your code at https://repobility.com

Embed Badge

Add to your README:

![Quality](https://repos.aljefra.com/badge/1369812.svg)
Quality BadgeSecurity Badge
Export Quality CSVDownload SBOMExport Findings CSV

BinComp Dependency Hardening

All packages →
21 of this repo's dependencies have been scanned for binary hardening. Grade reflects RELRO / stack canary / FORTIFY / PIE coverage.
Ntransformers5.5.3 · 0 gadgets · risk 10146.5Ftorch2.11.0 · 1,257 gadgets · risk 5116.6Nrequests2.33.1 · 0 gadgets · risk 3687.0Nanthropic0.95.0 · 0 gadgets · risk 846.6Nipython9.12.0 · 0 gadgets · risk 738.0Nflask3.1.3 · 0 gadgets · risk 574.2Npymysql1.1.2 · 0 gadgets · risk 264.6Nasyncio4.0.0 · 0 gadgets · risk 0.0Nboto31.42.88 · 0 gadgets · risk 0.0Nbotocore1.42.88 · 0 gadgets · risk 0.0Nclick8.3.2 · 0 gadgets · risk 0.0Nfastapi0.135.3 · 0 gadgets · risk 0.0Nhttpx0.28.1 · 0 gadgets · risk 0.0Fnumpy2.4.4 · 6,596 gadgets · risk 0.0Nopenai2.31.0 · 0 gadgets · risk 0.0Fpandas3.0.2 · 6,381 gadgets · risk 0.0Nplotly6.7.0 · 0 gadgets · risk 0.0Npydantic2.12.5 · 0 gadgets · risk 0.0Fsqlalchemy2.0.49 · 376 gadgets · risk 0.0Nsqlparse0.5.5 · 0 gadgets · risk 0.0Nuvicorn0.44.0 · 0 gadgets · risk 0.0