BaseDMS – An open-source, intelligent, AI-powered data management system based on browser

Introduction

BaseDMS is an open-source, free, and AI-powered intelligent data management system. It provides a web-based SQL editor for querying and managing database objects, and supports AI assisted development. Currently, it is compatible…


This content originally appeared on DEV Community and was authored by basedt

Introduction

BaseDMS is an open-source, free, and AI-powered intelligent data management system. It provides a web-based SQL editor for querying and managing database objects, and supports AI assisted development. Currently, it is compatible with more than 10 datasource including MySQL, Oracle, PostgreSQL, Apache Doris,Apache Hive and more.

Features

  • User-friendly: Provides a graphical web interface for intuitive and simple operation
  • Database Management: Supports common databases such as MySQL, Oracle, PostgreSQL, and more
  • SQL Editor: Offers a web-based SQL editor for online querying, with code suggestions and SQL file management
  • AI Integration: Enables AI LLM configuration and provides conversational AI assistance for development
  • Import/Export: Supports data import/export operations, with split configuration for exporting large tables
  • SQL Auditing: Tracks historical SQL execution records for administrator auditing and traceability

Screenshots

datasource

sql

table

import

Try DMS

Create or download docker-compose.yml file

services:

  db:
    image: postgres:15.1-alpine
    container_name: dms_postgres
    restart: always
    environment:
      POSTGRES_USER: root
      POSTGRES_PASSWORD: 123456
      POSTGRES_DB: dms
    ports:
      - 5432:5432
    volumes:
      - ./db/data:/var/lib/postgresql/data
    healthcheck:
      test: [ "CMD", "pg_isready", "-q", "-d", "dms", "-U", "-u$$POSTGRES_USER" ]
      interval: 30s
      timeout: 5s
      retries: 3
      start_period: 10s
    networks:
      - dms
  redis:
    image: redis:7.0.7
    container_name: dms_redis
    restart: always
    ports:
      - 6379:6379
    networks:
      - dms
  minio:
    image: bitnami/minio:2024
    container_name: dms_minio
    environment:
      - MINIO_ROOT_USER=admin
      - MINIO_ROOT_PASSWORD=password
      - MINIO_DEFAULT_BUCKETS=dms
    ports:
      - 9000:9000
      - 9001:9001
    networks:
      - dms
  dms-backend:
    image: basedt/dms-backend
    container_name: dms_backend
    depends_on:
      redis:
        condition: service_started
      minio:
        condition: service_started
      db:
        condition: service_healthy
    healthcheck:
      test: [ "CMD", "curl", "-f", "http://dms-backend:8080/dms/api/health/status" ]
    ports:
      - 8080:8080
      - 8366:8366
    networks:
      - dms
  dms-frontend:
    image: basedt/dms-frontend
    container_name: dms_frontend
    depends_on:
      dms-backend:
        condition: service_healthy
    ports:
      - 80:80
    networks:
      - dms

networks:
  dms:
    driver: bridge

Run following command to start the project

docker compose up -d

Open your browser and visit http://localhost to access dms. you can register an account or log in with admin account (admin/123456).


This content originally appeared on DEV Community and was authored by basedt


Print Share Comment Cite Upload Translate Updates
APA

basedt | Sciencx (2025-08-15T03:42:51+00:00) BaseDMS – An open-source, intelligent, AI-powered data management system based on browser. Retrieved from https://www.scien.cx/2025/08/15/basedms-an-open-source-intelligent-ai-powered-data-management-system-based-on-browser/

MLA
" » BaseDMS – An open-source, intelligent, AI-powered data management system based on browser." basedt | Sciencx - Friday August 15, 2025, https://www.scien.cx/2025/08/15/basedms-an-open-source-intelligent-ai-powered-data-management-system-based-on-browser/
HARVARD
basedt | Sciencx Friday August 15, 2025 » BaseDMS – An open-source, intelligent, AI-powered data management system based on browser., viewed ,<https://www.scien.cx/2025/08/15/basedms-an-open-source-intelligent-ai-powered-data-management-system-based-on-browser/>
VANCOUVER
basedt | Sciencx - » BaseDMS – An open-source, intelligent, AI-powered data management system based on browser. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2025/08/15/basedms-an-open-source-intelligent-ai-powered-data-management-system-based-on-browser/
CHICAGO
" » BaseDMS – An open-source, intelligent, AI-powered data management system based on browser." basedt | Sciencx - Accessed . https://www.scien.cx/2025/08/15/basedms-an-open-source-intelligent-ai-powered-data-management-system-based-on-browser/
IEEE
" » BaseDMS – An open-source, intelligent, AI-powered data management system based on browser." basedt | Sciencx [Online]. Available: https://www.scien.cx/2025/08/15/basedms-an-open-source-intelligent-ai-powered-data-management-system-based-on-browser/. [Accessed: ]
rf:citation
» BaseDMS – An open-source, intelligent, AI-powered data management system based on browser | basedt | Sciencx | https://www.scien.cx/2025/08/15/basedms-an-open-source-intelligent-ai-powered-data-management-system-based-on-browser/ |

Please log in to upload a file.




There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.