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

[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:


Latest release:


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

[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

[SelfProduction™]

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:


Latest release:


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

Thanks for your work bro!