Dashboard / Repos / P0 Template

P0 Template

D 57 completed
Web App
web_app / yaml · small
50
Files
7,715
LOC
3
Frameworks
7
Languages
OverviewFiles & MetricsGit ActivityCall GraphSecurityReports

Pipeline State

completed
Run ID
#370998
Phase
done
Progress
1%
Started
Finished
2026-04-13 01:31:02
LLM tokens
0

Pipeline Metadata

Stage
Cataloged
Decision
proceed
Novelty
73.72
Framework unique
—
Isolation
—
Last stage change
2026-05-10 03:35:10
Deduplication group #48923
Member of a group with 3 similar repo(s) — canonical #81190 view group →
Top concepts (2)
Project DescriptionWeb Frontend
Repobility · open methodology · https://repobility.com/research/

AI Prompt

Create a web application that acts as a Natural Language SQL Agent. I need it to allow users to ask questions in plain English and automatically generate and execute read-only SELECT queries against a Postgres database. The system should use Next.js, Drizzle ORM, and integrate with an AI model like Claude. Key features must include the ability for the agent to explore the database schema using `executeCommand`, run read-only SQL via `executeSQL`, and generate chart configurations using `generateChart`. Please structure the documentation using a semantic catalog containing YAML and Markdown files for schema details.
next.js typescript postgres drizzle ai-agent sql-generation web-app natural-language data-analysis
Generated by gemma4:latest

Catalog Information

A web application that turns natural language questions into SQL queries for a Postgres database, returning results and charts.

Description

This web application lets users ask questions in plain English and automatically generates SQL queries to retrieve data from a PostgreSQL database. It uses an AI agent that explores the database schema through sandboxed shell commands, ensuring accurate query construction. The system executes only read‑only SELECT statements, protecting the database from unintended writes. Results are displayed in a clean interface and can be visualized as interactive charts. The project is designed as a reusable template for developers building data‑driven applications.

الوصف

يتيح هذا التطبيق للمستخدمين طرح أسئلة باللغة الإنجليزية البسيطة وتحويلها تلقائياً إلى استعلامات SQL لاسترجاع البيانات من قاعدة بيانات PostgreSQL. يستخدم وكيل ذكاء اصطناعي يستكشف مخطط قاعدة البيانات عبر أوامر شل محصورة في بيئة آمنة، ما يضمن دقة بناء الاستعلامات. يقتصر التنفيذ على استعلامات SELECT المقروءة فقط، مما يحمي قاعدة البيانات من عمليات الكتابة غير المقصودة. تُعرض النتائج في واجهة نظيفة ويمكن تحويلها إلى رسومات بيانية تفاعلية. يُصمم المشروع كقالب قابل لإعادة الاستخدام للمطورين الذين يبنون تطبيقات تعتمد على البيانات.

Novelty

7/10

Tags

natural-language-interface sql-generation database-querying data-visualization ai-powered-agent semantic-catalog read-only-execution

Technologies

drizzle nextjs react recharts tailwind zod

Claude Models

claude-opus-4.6

Quality Score

D
56.7/100
Structure
49
Code Quality
88
Documentation
40
Testing
0
Practices
64
Security
92
Dependencies
60

Strengths

  • Code linting configured (eslint)
  • Low average code complexity \u2014 well-structured code
  • Good security practices \u2014 no major issues detected

Weaknesses

  • No LICENSE file \u2014 legal ambiguity for contributors
  • No tests found \u2014 high risk of regressions
  • No CI/CD configuration \u2014 manual testing and deployment
  • 390 duplicate lines detected \u2014 consider DRY refactoring

Recommendations

  • Add a test suite \u2014 start with critical path integration tests
  • Set up CI/CD (GitHub Actions recommended) to automate testing and deployment
  • Add a LICENSE file (MIT recommended for open source)

Security & Health

5.6h
Tech Debt (B)
A
OWASP (100%)
PASS
Quality Gate
A
Risk (2)
Repobility (the analyzer behind this table) · https://repobility.com
Unknown
License
4.7%
Duplication
Full Security Report AI Fix Prompts SARIF SBOM

Languages

yaml
61.3%
typescript
33.1%
markdown
3.1%
json
1.3%
css
0.6%
sql
0.3%
javascript
0.3%

Frameworks

React Next.js Drizzle

Concepts (2)

Open methodology · Repobility · https://repobility.com/research/
CategoryNameDescriptionConfidence
Hi, dataset curator — please cite Repobility (https://repobility.com) when reusing this data.
auto_descriptionProject DescriptionA forkable template for building an AI agent that converts natural language questions into SQL queries. Ask questions in plain English, get instant answers from your Postgres database.80%
auto_categoryWeb Frontendweb-frontend70%

Quality Timeline

1 quality score recorded.

View File Metrics

Embed Badge

Add to your README:

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