[Release] 4Story SQL Manager – Free & Open Source SQL Server Tool

Quote:

Originally Posted by YellowSwag Hi everyone, I’m releasing a small SQL Server manager I built recently as a free alternative to Navicat. It was originally made for 4Story development, but it works with any SQL Server database. The project is open source (MIT) and fully available on GitHub. Features SQL Server connection support Browse databases, tables, and functions Inline table editing (double-click cells) Add / delete rows Copy tables between databases Execute functions with parameters Dark theme code editor Multi-tab support Portable (no installation required) Smart Search Search across: Table names Function names Table data Fuzzy matching (handles typos) Shows exact table / column / value matches Useful when you remember data but not where it’s stored. Download & Source GitHub repository: [Only registered and activated users can see links. Click Here To Register...] Latest release: [Only registered and activated users can see links. Click Here To Register...] Technical Info Electron 39.2.7 React 19 Fluent UI Windows x64 Portable build Windows Defender may report a false positive (Electron-related). Feedback, bug reports, and feature requests are welcome. YellowSwag :D [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by YellowSwag UPDATE! Change log 1.10  Spoiler Pagination System​ Table Pagination: Added pagination controls for tables with more than 1000 rows Previous/Next Buttons: Navigate through large datasets easily Page Counter: Shows current page, total pages, and total row count Smart Loading: Only loads 1000 rows per page for optimal performance Context Menu System (Right-Click)​ Universal Context Menus: Right-click anywhere for quick actions Works in tree view (sidebar) Works in grid view Works in list view Works in details view Tables Context Menu: Open Table Copy Table Paste Table (when available) Rename Table Delete Table Functions Context Menu: Open Function Rename Function Delete Function Database Context Menu: Backup Database Paste Table (when available) Keyboard Shortcuts​ Ctrl+F: Open Smart Search from anywhere Ctrl+N: Create New Table (when in tables view) Ctrl+Shift+N: Create New Function (when in functions view) Escape: Close context menus CRUD Operations​ Create Table: Visual table designer with interactive column editor Add/remove columns dynamically Configure data types, length, primary key, identity, NOT NULL Schema and table name selection Column-by-column configuration Create Function/Procedure: Full SQL editor for creating routines Syntax examples provided Supports both functions and procedures Delete Functions: Delete stored procedures and functions from all views Enhanced Delete: Delete buttons for both tables and functions in all view modes 🔍 Search Improvements​ Full Table Search: Search now queries entire table, not just current page Server-Side Search: Filtering performed at database level for better performance All Columns Search: Searches across all columns automatically Clear Search Button: Quickly clear search filters Result Counter: Shows "Filtered" vs "Total" counts when searching 🎨 UI/UX Improvements​ Larger Window: Increased from 1400x900 to 1600x1000 pixels for better visibility Optimized Dialogs: All dialogs properly sized to avoid unnecessary scrollbars Create Table Dialog: 700-900px width, 90vh max height Create Function Dialog: 700-900px width, 90vh max height Smart Search Dialog: 650-850px width, 90vh max height Run Function Dialog: 500-800px width, 90vh max height All other dialogs optimized Better Function Editor: SQL editor increased from 400px to 500px minimum height Cleaner Toolbar: Removed redundant buttons, moved to context menus Professional Menus: Native-looking context menus with icons, separators, and hover effects Optimized Content Areas: Better use of vertical space with adjusted max heights 🔒 Database Filtering​ System Databases Hidden: Filters out master, tempdb, model, msdb automatically User Databases Only: Cleaner interface showing only your custom databases 🐛 Bug Fixes​ Fixed table search to work across entire dataset instead of just loaded page Fixed pagination to properly track and display total row counts Improved copy/paste workflow with better user feedback Fixed paste functionality - can now paste to any database via context menu Resolved issues with context menu positioning 🏗️ Technical Improvements​ Backend pagination with offset/limit support Server-side WHERE clause filtering for searches Enhanced IPC handlers for CRUD operations (create-table, create-function, delete-function) Context menu state management system Global keyboard event handling Improved data flow for table operations