NeoServer SSH Mosh Terminal vs SQL Guide

NeoServer manages your servers over SSH, with no extra software to install. Whether it's a Home Server, NAS, cloud server, development environment, or AI compute node, you can connect, monitor, manage files, and operate containers directly through NeoServer. ◉ Terminal and Remote Access • Mosh support — stays connected when switching networks • Deep tmux and zellij support for fast session recovery after disconnects • ZMODEM (rz/sz) file transfer — send and receive files right in the terminal • Built for Claude Code, with direct paste or upload of images, videos, and files • Password, Private Key, 2FA, and SSH Agent forward authentication • Jump Server, Failover, and Socks5 Proxy support • Automatically run Shell initialization scripts after connecting • Built-in special keyboard, copy and paste, and quick actions • Command completion hints, with double-tap to trigger TAB • Custom themes and fonts, including programming ligature fonts ◉ AI Assistant No Agent installation required. Manage your servers directly with AI: it can read metrics, run commands, and manage files — like an always-on operations assistant that helps you handle complex maintenance tasks. • Supports mainstream LLM APIs via standard protocols. No model service is included — bring your own API configuration for any provider you need • Custom Skills system: AI can read and create skills, synced across devices via iCloud • Built-in browser skill: AI can open web pages, extract content, and run scripts in-app • Local file sandbox: AI can read and write local files with live preview • Runs continuously in the background, with automatic notifications when tasks complete • Upload images, screenshots, and files for AI to analyze in context • Plan mode: plan first, then execute — more control over complex tasks ◉ File Management (SFTP) • Browse server files and directories • Upload, download, delete, and rename files • View file size, permissions, and modification time • Edit files online • Syntax highlighting for common programming languages • Preview images, logs, configuration files, and more ◉ Batch Script Execution • Run scripts on one or multiple servers • Organize servers into groups • View script execution history • Run maintenance tasks in batches at once • Suitable for batch updates, deployments, and inspections ◉ Server Monitoring View server status in real time: • Uptime • 1 / 5 / 15 minute system load • CPU model, temperature, and usage • Memory usage • GPU usage and GPU task information • Disk capacity, IOPS, and I/O Wait • Disk read/write speed and total read/write volume • Network upload and download speed • Total traffic statistics Key metrics can also be shown directly in iOS widgets. ◉ Process Management • View the system process list • Show PID, user, CPU, memory usage, and more • Sort by columns • Send signals to terminate processes ◉ Docker and Podman Management • View container status • View container logs • View Inspect information • Create, start, stop, and restart containers • Pause and delete containers • Manage images and container resources ◉ Remote Wake and Automation • Wake-on-LAN (WOL) remote startup • Remote shutdown and daily operations support ◉ Security and Data Sync • Face ID / Touch ID app protection • Sync data with your private iCloud storage ◉ Who NeoServer Is For • Home Server enthusiasts • NAS users (Synology, QNAP, TrueNAS, and more) • Website administrators and operations engineers • Developers and programmers • AI model researchers • Cloud server administrators ◉ Feedback and issues: makerneo.lab@gmail.com ◉ Data Privacy: ◦ Your private data — such as SSH private keys and server configurations — is stored only on your device and your own iCloud storage (if you enable sync). It is never uploaded to our servers or shared with any third party. ◦ Privacy Policy: https://www.makerneo.com/en/doc/neoserver-privacy.html ◦ Terms of Use: https://www.apple.com/legal/internet-services/itunes/dev/stdeula/

SQLGuide — Learn SQL, One Chapter at a Time SQLGuide is a modern, lightweight SQL learning app built around short chapters, interactive quizzes, and a practical reference library. It is designed for beginners who want to learn core SQL concepts clearly and build confidence with real query patterns. Learn by doing SQLGuide combines guided reading with quick practice so you can move from understanding → recall → application: - Read a chapter with focused explanations and examples - Practice with multiple quiz formats - Keep a reference library for fast lookups - Bookmark what matters and come back later Guide (SQL Basics) Progress through a structured curriculum that starts from fundamentals and builds up step by step: - Queries: SELECT, DISTINCT, LIMIT - Filtering: WHERE, AND/OR, IN, BETWEEN, LIKE - Sorting and grouping: ORDER BY, GROUP BY, HAVING - Aggregation: COUNT, SUM, AVG, MIN, MAX - Joins: INNER/LEFT/RIGHT, practical join patterns - Data shaping: CASE, COALESCE, NULL handling - Subqueries, CTEs, UNION - Basic DDL/DML concepts: CREATE TABLE, INSERT, UPDATE, DELETE (concepts and patterns) Quiz (with explanations) Practice with short, focused prompts that reinforce both syntax and reasoning: - Clear explanations after each question to help you learn from mistakes - SQL snippets and realistic scenarios that mirror everyday query work - Smooth “continue” flow to keep you moving without friction - Progress tracking that shows what you have mastered and what is next Reference (quick SQL lookup) A curated reference list for frequently used SQL topics, with concise notes and examples to reduce context switching while you learn. Bookmarks and progress - Bookmark chapters and reference topics - Track course progress and quiz completion - Earn badges as you complete milestones Who this is for - Students learning SQL fundamentals - Developers refreshing core SQL skills - Analysts practicing queries and concepts - Anyone preparing for SQL interviews or assessments Privacy and access No account required. No login. No external sign-in at all. Everything is free. Download and get all content immediately.