Data

Tools

Indexes

Applications

Experiments

Open Source Science

https://github.com/basharst99/university-database-chatbot

https://github.com/basharst99/university-database-chatbot

Science Score: 26.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • ○
    CITATION.cff file
  • ✓
    codemeta.json file
    Found codemeta.json file
  • ✓
    .zenodo.json file
    Found .zenodo.json file
  • ○
    DOI references
  • ○
    Academic publication links
  • ○
    Academic email domains
  • ○
    Institutional organization owner
  • ○
    JOSS paper metadata
  • ○
    Scientific vocabulary similarity
    Low similarity (4.2%) to scientific vocabulary
Last synced: 10 months ago · JSON representation

Repository

Basic Info
  • Host: GitHub
  • Owner: BasharST99
  • Language: Python
  • Default Branch: master
  • Size: 25.4 KB
Statistics
  • Stars: 0
  • Watchers: 0
  • Forks: 0
  • Open Issues: 0
  • Releases: 0
Created 12 months ago · Last pushed 12 months ago
Metadata Files
Readme

README.md

University Chatbot with NLP-to-SQL

Python Django OpenAI

An AI-powered chatbot that converts natural language questions about university data into SQL queries, supporting both English and Arabic.

Key Features

  • Natural Language Processing: Translates plain English/Arabic into SQL
  • Complex Query Support: Handles JOINs, GROUP BY, and subqueries
  • Bilingual UI: RTL/LTR responsive interface
  • Query Logging: Tracks user questions for model improvement

Tech Stack

  • Backend: Django + Vanna.AI
  • Database: MySQL
  • AI: OpenAI GPT-3.5
  • Frontend: Bootstrap 5

Setup

  1. Clone repo: ```bash git clone https://github.com/yourusername/university-chatbot.git

Owner

  • Name: Bashar Telfah
  • Login: BasharST99
  • Kind: user
  • Location: Amman,jordan

Software Engineer | Full Stack | React, Next.js, Python, TypeScript, Django | Passionate About Building Scalable Systems

GitHub Events

Total
  • Push event: 1
  • Create event: 1
Last Year
  • Push event: 1
  • Create event: 1

Dependencies

requirements.txt pypi
  • Automat ==20.2.0
  • Babel ==2.8.0
  • Django ==5.2.3
  • Eel ==0.14.0
  • Faker ==37.4.0
  • Flask ==3.1.1
  • GitPython ==3.1.44
  • Jinja2 ==3.1.6
  • MarkupSafe ==3.0.2
  • Pillow ==10.1.0
  • PyGObject ==3.42.1
  • PyHamcrest ==2.0.2
  • PyJWT ==2.3.0
  • PyMySQL ==1.1.1
  • PyPika ==0.48.9
  • PySocks ==1.7.1
  • PyYAML ==6.0.2
  • Pygments ==2.19.2
  • SQLAlchemy ==2.0.41
  • SecretStorage ==3.3.1
  • Twisted ==22.1.0
  • Werkzeug ==3.1.3
  • altair ==5.5.0
  • annotated-types ==0.7.0
  • antiorm ==1.2.1
  • anyio ==4.9.0
  • asgiref ==3.8.1
  • asttokens ==3.0.0
  • async-generator ==1.10
  • attrs ==25.3.0
  • backoff ==2.2.1
  • bcrypt ==4.3.0
  • beautifulsoup4 ==4.11.1
  • blinker ==1.9.0
  • bottle ==0.12.23
  • bottle-websocket ==0.2.9
  • bs4 ==0.0.1
  • build ==1.2.2.post1
  • cachetools ==5.5.2
  • certifi ==2022.9.24
  • cffi ==1.15.1
  • chardet ==4.0.0
  • charset-normalizer ==2.1.1
  • choreographer ==1.0.9
  • chroma-hnswlib ==0.7.6
  • chromadb ==0.6.3
  • click ==8.2.1
  • cloud-init ==24.4
  • colorama ==0.4.4
  • coloredlogs ==15.0.1
  • comm ==0.2.2
  • command-not-found ==0.3
  • configobj ==5.0.6
  • constantly ==15.1.0
  • contourpy ==1.2.0
  • crispy-bootstrap5 ==2025.6
  • cryptography ==3.4.8
  • cycler ==0.12.1
  • db ==0.1.1
  • db-sqlite3 ==0.0.1
  • dbus-python ==1.2.18
  • debugpy ==1.8.14
  • decorator ==5.2.1
  • distro ==1.7.0
  • distro-info ==1.1
  • django-crispy-forms ==2.4
  • durationpy ==0.10
  • exceptiongroup ==1.3.0
  • executing ==2.2.0
  • fastapi ==0.115.14
  • filelock ==3.18.0
  • flasgger ==0.9.7.1
  • flask-sock ==0.7.0
  • flatbuffers ==25.2.10
  • fonttools ==4.44.0
  • fsspec ==2025.5.1
  • future ==0.18.2
  • gevent ==22.10.2
  • gevent-websocket ==0.10.1
  • gitdb ==4.0.12
  • google-auth ==2.40.3
  • googleapis-common-protos ==1.70.0
  • greenlet ==2.0.1
  • grpcio ==1.73.1
  • gyp ==0.1
  • h11 ==0.16.0
  • hf-xet ==1.1.5
  • httpcore ==1.0.9
  • httplib2 ==0.20.2
  • httptools ==0.6.4
  • httpx ==0.28.1
  • huggingface-hub ==0.33.1
  • humanfriendly ==10.0
  • hyperlink ==21.0.0
  • idna ==3.4
  • importlib_metadata ==8.7.0
  • importlib_resources ==6.5.2
  • incremental ==21.3.0
  • ipykernel ==6.29.5
  • ipython ==8.37.0
  • itsdangerous ==2.2.0
  • jedi ==0.19.2
  • jeepney ==0.7.1
  • jiter ==0.10.0
  • jsonpatch ==1.32
  • jsonpointer ==2.0
  • jsonschema ==4.24.0
  • jsonschema-specifications ==2025.4.1
  • jupyter_client ==8.6.3
  • jupyter_core ==5.8.1
  • kaleido ==1.0.0
  • keyring ==23.5.0
  • kiwisolver ==1.4.5
  • kubernetes ==33.1.0
  • launchpadlib ==1.10.16
  • lazr.restfulclient ==0.14.4
  • lazr.uri ==1.0.6
  • logistro ==1.1.0
  • lxml ==5.2.1
  • markdown-it-py ==3.0.0
  • matplotlib ==3.8.1
  • matplotlib-inline ==0.1.7
  • mdurl ==0.1.2
  • mistune ==3.1.3
  • mmh3 ==5.1.0
  • more-itertools ==8.10.0
  • mpmath ==1.3.0
  • mysql-connector-python ==9.3.0
  • mysqlclient ==2.2.7
  • narwhals ==1.44.0
  • nest-asyncio ==1.6.0
  • netifaces ==0.11.0
  • numpy ==1.26.1
  • oauthlib ==3.3.1
  • onnxruntime ==1.22.0
  • openai ==1.93.0
  • opentelemetry-api ==1.34.1
  • opentelemetry-exporter-otlp-proto-common ==1.34.1
  • opentelemetry-exporter-otlp-proto-grpc ==1.34.1
  • opentelemetry-instrumentation ==0.55b1
  • opentelemetry-instrumentation-asgi ==0.55b1
  • opentelemetry-instrumentation-fastapi ==0.55b1
  • opentelemetry-proto ==1.34.1
  • opentelemetry-sdk ==1.34.1
  • opentelemetry-semantic-conventions ==0.55b1
  • opentelemetry-util-http ==0.55b1
  • orjson ==3.10.18
  • outcome ==1.2.0
  • overrides ==7.7.0
  • packaging ==23.2
  • pandas ==2.3.0
  • parso ==0.8.4
  • pexpect ==4.9.0
  • platformdirs ==4.3.8
  • plotly ==6.2.0
  • posthog ==6.0.0
  • prompt_toolkit ==3.0.51
  • protobuf ==5.29.5
  • psutil ==7.0.0
  • ptyprocess ==0.7.0
  • pure_eval ==0.2.3
  • pyOpenSSL ==21.0.0
  • pyarrow ==20.0.0
  • pyasn1 ==0.4.8
  • pyasn1-modules ==0.2.1
  • pybase64 ==1.4.1
  • pycparser ==2.21
  • pycurl ==7.44.1
  • pydantic ==2.11.7
  • pydantic_core ==2.33.2
  • pydeck ==0.9.1
  • pyparsing ==3.0.9
  • pyproject_hooks ==1.2.0
  • pyrsistent ==0.18.1
  • pyserial ==3.5
  • pyshorteners ==1.0.1
  • python-apt ==2.4.0
  • python-dateutil ==2.8.2
  • python-dotenv ==1.0.1
  • pytz ==2022.1
  • pyzmq ==27.0.0
  • referencing ==0.36.2
  • requests ==2.28.1
  • requests-oauthlib ==2.0.0
  • rich ==14.0.0
  • rpds-py ==0.25.1
  • rsa ==4.9.1
  • scipy ==1.11.3
  • selenium ==4.6.0
  • service-identity ==18.1.0
  • shellingham ==1.5.4
  • simple-websocket ==1.1.0
  • simplejson ==3.20.1
  • six ==1.16.0
  • smmap ==5.0.2
  • sniffio ==1.3.0
  • sortedcontainers ==2.4.0
  • soupsieve ==2.3.2.post1
  • sqlparse ==0.5.3
  • stack-data ==0.6.3
  • starlette ==0.46.2
  • streamlit ==1.46.1
  • sympy ==1.14.0
  • systemd-python ==234
  • tabulate ==0.9.0
  • tenacity ==9.1.2
  • tokenizers ==0.21.2
  • toml ==0.10.2
  • tomli ==2.2.1
  • tornado ==6.5.1
  • tqdm ==4.67.1
  • traitlets ==5.14.3
  • trio ==0.22.0
  • trio-websocket ==0.9.2
  • typer ==0.16.0
  • typing-inspection ==0.4.1
  • typing_extensions ==4.12.2
  • tzdata ==2025.2
  • ubuntu-pro-client ==8001
  • ufw ==0.36.1
  • unattended-upgrades ==0.1
  • urllib3 ==1.26.12
  • uvicorn ==0.34.3
  • uvloop ==0.21.0
  • wadllib ==1.3.6
  • watchdog ==6.0.0
  • watchfiles ==1.1.0
  • wcwidth ==0.2.13
  • webdriver-manager ==4.0.2
  • websocket-client ==1.8.0
  • websockets ==15.0.1
  • whichcraft ==0.6.1
  • wrapt ==1.17.2
  • wsproto ==1.2.0
  • zipp ==3.23.0
  • zope.event ==4.5.0
  • zope.interface ==5.5.1