News

📰 News

Latest updates and new features from SysEmperor.

New Tool: EXPLAIN Query Analyzer for PostgreSQL

May 28, 2026

SysEmperor just launched the EXPLAIN Query Analyzer — a free, browser-based tool that turns raw PostgreSQL query plans into plain-English bottleneck reports with ready-to-run fixes.

What it does

Paste the output of EXPLAIN (ANALYZE, BUFFERS) — with or without your original SQL — click Analyze, and the tool immediately tells you:

  • Which nodes are slow — each bottleneck is flagged with a severity level (High / Medium) and the percentage of total execution time it consumed
  • Why it's slow — plain-English explanation of what the node is doing and why that's a problem for your data volume
  • What to do about it — specific, copy-ready SQL snippets for indexes, ANALYZE calls, and work_mem settings

What it detects

  • Sequential scans on large tables — if you also paste the SQL query, the tool reads your ON, WHERE, and ORDER BY clauses to suggest the exact column and index name to create
  • Stale statistics — when PostgreSQL's row-count estimate is off by 10× or more, the planner picks wrong join types and sort strategies; the tool flags it and tells you which table to ANALYZE
  • Disk sorts — Sort Method: external merge Disk means the sort spilled to temporary files because it exceeded work_mem; the tool gives you the exact setting to change
  • Nested Loop at scale — loops with a large iteration product that would benefit from an inner-side index or a Hash Join
  • HashAggregate disk spill — aggregation that batched to disk due to memory pressure

How to use it

Run this in psql or any PostgreSQL client, then paste the output into the tool:

EXPLAIN (ANALYZE, BUFFERS, FORMAT TEXT) SELECT …;

Everything runs in your browser — no query data is sent anywhere.

Two New Free Tools: Project Planner with Gantt Chart & chmod Calculator

May 4, 2026

SysEmperor just added two new browser-based developer tools — free to use, no sign-up, no data sent to any server.

Project Planner — Visual Gantt Chart for Developers

The Project Planner is a full-featured project and task management tool that runs entirely in your browser.

Key features:

  • Interactive Gantt chart — drag and resize task bars directly on the timeline to reschedule work
  • Nested projects and tasks — organize work into projects, sub-projects, and subtasks with unlimited depth
  • Dependency arrows — visually link tasks that block each other so critical paths are immediately obvious
  • Four zoom levels — switch between day, week, month, and quarter views to zoom in on sprints or zoom out for roadmaps
  • Detail panel — set priority, status, start date, duration, and deadline per task with a click
  • Workspace persistence — save your entire workspace as a JSON file or to browser storage, and reload it any time
  • No account required — your project data never leaves your machine

This tool is built for developers and sysadmins who want fast, lightweight project visibility without subscribing to Jira or Notion.

chmod Calculator — Build Linux File Permissions Visually

The chmod Calculator removes the guesswork from Linux file permission management.

Key features:

  • Visual permission builder — toggle read, write, and execute bits for owner, group, and others using checkboxes instead of memorizing octal
  • Import from ls -l output — paste a permissions string like -rwxr-xr-- and the tool decodes it instantly
  • Octal import — enter 755, 644, or any other octal code and see the full permission breakdown
  • Live chmod command — the correct chmod command updates in real time as you build your permissions, ready to copy and run
  • Covers all common cases — setuid, setgid, sticky bit included

Whether you're configuring a web server, writing deploy scripts, or studying for the LPIC or CompTIA Linux+ exam, the chmod Calculator gives you the exact command you need in seconds.

AI Skills — Skill File Downloads Now Available

April 27, 2026

The AI Skills section now offers direct skill file downloads alongside every prompt. Click the Download button on any skill page to save the .md file straight to your machine — ready to drop into your Claude skills directory and use immediately as a slash command.

This makes the workflow end-to-end: read the prompt, understand what it does, then install it in one click instead of copying and pasting manually. The downloaded file already includes the correct frontmatter and formatting that Claude expects, so there's no extra editing required.

All existing skills in the Education category — Certifications and School — are covered.

AI Skills & Tutorials — Free Learning Resources Now Live

April 20, 2026

SysEmperor just launched two brand-new sections: AI Skills and Tutorials — completely free, no Pro account required, for everyone.

Find them in the top navigation bar, right next to the logo.

AI Skills

A growing library of ready-to-use prompts organized by category. Stop writing the same instructions from scratch every session — copy a proven prompt, paste it into your AI tool of choice, and get better results immediately.

The first category is Education, with two subcategories:

  • Certifications — Prompts for AWS Cloud Practitioner, CompTIA Security+, Google Professional Cloud Architect, and Kubernetes CKA exam preparation. Each prompt includes a structured study plan, practice questions, and tips for getting the most out of your AI sessions.
  • School — Prompts for essay writing feedback, step-by-step math tutoring, research paper outlines, foreign language conversation practice, and science concept explanations. Tuned for students at every level.

More categories are on the way — covering development, DevOps, system administration, and beyond.

Tutorials

Step-by-step guides focused on practical AI workflows. The first tutorial in the AI category covers How to Implement a Skill into Claude — a complete walkthrough for importing a custom slash command created by someone else into your own Claude Code environment, including directory setup, file placement, tab-completion verification, and troubleshooting.

Tutorials are written for developers who want clear, no-fluff instructions they can follow in minutes.

Why Free?

AI prompts and tutorials make every developer faster, regardless of budget. These resources belong to the community — gated content would defeat the point.

Expect new prompts and tutorials to appear regularly. Check this page for updates.

Cron Visual Editor — Export to Excel & Markdown

March 11, 2026

The Cron Visual Editor now includes a Document export feature. Click the Document ▾ button in the toolbar (next to Download) to export your crontab as a document, ready to archive, in your choice of format:

  • Excel (.xlsx) — A spreadsheet with Status, Schedule, individual cron fields (MIN, HOUR, DOM, MON, DOW), Command, and a plain-English explanation for each entry
  • Markdown (.md) — A portable Markdown table with the same content, plus a generation timestamp

On desktop, hover over the button to reveal the format picker. On mobile, tap it to open the menu.

This feature is part of our ongoing effort to make SysEmperor a complete workflow for developers who need to design, develop, and document their applications — including infrastructure scheduled through cron.