explaingit

duhbbx/skylerx

21VueAudience · developerComplexity · 2/5Setup · easy

TLDR

A free desktop app for browsing and managing databases including MySQL, PostgreSQL, MongoDB, and Redis, with a built-in AI assistant for writing and optimizing queries.

Mindmap

mindmap
  root((SkylerX))
    Supported Databases
      MySQL PostgreSQL SQLite
      MongoDB Redis
      ClickHouse DuckDB
      Snowflake Oracle
    Query Tools
      Code editor syntax highlight
      Scrollable results grid
      Chart visualization
    Schema Tools
      Visual table designer
      ER diagram viewer
      Schema comparison
      Backup and restore
    AI Assistant
      Write queries
      Explain structures
      SQL dialect translation
    Platform
      Windows Mac Linux
      Electron app
Click or tap to explore — scroll the page freely

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

Things people build with this

USE CASE 1

Connect to and query multiple databases like MySQL, PostgreSQL, and MongoDB from a single desktop app.

USE CASE 2

Visualize your database schema as an ER diagram to understand table relationships without writing any code.

USE CASE 3

Ask the AI assistant to write SQL queries, explain a schema, or translate a query from MySQL syntax to PostgreSQL.

Tech stack

VueElectronTypeScript

Getting it running

Difficulty · easy Time to first run · 5min

Pre-release software, back up all databases before using any write or modify features.

In plain English

SkylerX is a free desktop application for browsing and managing databases, positioned as an alternative to commercial tools like Navicat or DBeaver. It runs on Windows, Mac, and Linux and is built using Electron, which packages a web-style interface into a native desktop app. The tool connects to a wide range of databases. On the SQL side it supports MySQL, PostgreSQL, SQL Server, Oracle, SQLite, DuckDB, ClickHouse, and Snowflake, among others. It also supports non-relational databases including MongoDB, Redis, and Elasticsearch. You can write and run queries in a code editor with syntax highlighting, view results in a scrollable grid, edit data directly, and visualize query output as charts. Beyond basic querying, SkylerX includes tools for inspecting and modifying database structure: a visual table designer, an ER diagram viewer, schema comparison between two databases, and a backup and restore wizard that does not depend on external utilities like mysqldump. There is a built-in AI assistant that connects to providers like Anthropic, OpenAI, or DeepSeek and can help write queries, explain database structures, suggest optimizations, and translate SQL between different database dialects. The project is developed by a company in China and is still in active pre-release development. The README cautions that it has not been fully tested in production environments and recommends backing up databases before using any features that write or modify data. Downloads are available as desktop installers through GitHub releases.

Copy-paste prompts

Prompt 1
I'm using SkylerX connected to a PostgreSQL database. Generate a query that finds all users who signed up in the last 30 days and have made at least one purchase.
Prompt 2
Using SkylerX's AI assistant, translate this MySQL query to PostgreSQL syntax: SELECT * FROM orders WHERE DATE(created_at) = CURDATE() AND status = 'pending',
Prompt 3
I need to compare two PostgreSQL schemas to find columns that exist in production but not in staging. Walk me through using SkylerX's schema comparison feature to do this.
Open on GitHub → Explain another repo

← duhbbx on gitmyhub — every repo by this author, as a profile.

Verify against the repo before relying on details.