Launch: scmd.exe --interactive or scmd.exe -i
Best for: Daily command-line usage, quick searches, natural language queries
Features:
- ✓ Natural language queries
- ✓ Direct keyword search
- ✓ Slash commands (/help, /search, /add, /list, /count, /exit)
- ✓ Quick shortcuts (help, clear, exit work without /)
- ✓ Persistent session
- ✓ Formatted output
- ✓ User-friendly prompts
- ✓ Built-in help
Example:
scmd> provide me with postgresql replication on master example
scmd> /add docker logs -f myapp | Follow application logs
scmd> /list
scmd> exit
Launch: scmd.exe --search "pattern" or scmd.exe --save "cmd" "desc"
Best for: Scripting, automation, one-off queries
Features:
- ✓ Single command execution
- ✓ Scriptable
- ✓ Exit after execution
- ✓ JSON output support
- ✓ Comma-separated patterns
Example:
scmd.exe --search "postgresql replication"
scmd.exe --save "docker ps -a" "List all containers"Launch: scmd.exe --web or scmd.exe --web -port 8080
Best for: Team sharing, visual browsing, remote access
Features:
- ✓ Browser-based interface
- ✓ Visual search results
- ✓ Add commands via form
- ✓ Syntax highlighting for code
- ✓ SSL/HTTPS support
- ✓ Read-only mode (-block)
- ✓ Service mode (no browser launch)
Example:
scmd.exe --web -port 3333
scmd.exe --web -port 8080 -block
scmd.exe --ssl -port 443 cert.pem key.pem| Feature | Interactive CLI | Traditional CLI | Web Interface |
|---|---|---|---|
| Natural Language | ✓ | ✗ | ✗ |
| Pattern Search | ✓ | ✓ | ✓ |
| Add Commands | ✓ | ✓ | ✓ |
| List Commands | ✓ | ✗ | ✓ |
| Count Commands | ✓ | ✗ | ✗ |
| Persistent Session | ✓ | ✗ | ✓ |
| Scriptable | ✗ | ✓ | ✗ |
| Remote Access | ✗ | ✗ | ✓ |
| SSL/HTTPS | ✗ | ✗ | ✓ |
| Syntax Highlighting | ✓ | ✓ | ✓ |
| Multi-user | ✗ | ✗ | ✓ |
All modes support:
- Case-insensitive search (PostgreSQL ILIKE)
- Multiple patterns (comma-separated)
- Search in both commands and descriptions
- Ordered results by ID
Examples:
postgresql replication → Single pattern
docker,kubernetes → Multiple patterns
git branch,git merge → Related patterns
Automatically extracts keywords from questions:
Input: "provide me with postgresql replication on master example" Extracted: "postgresql replication master"
Input: "how to check docker container logs" Extracted: "check docker container logs"
Interactive Mode:
scmd> /add docker ps -a | List all containers
Traditional CLI:
scmd.exe --save "docker ps -a" "List all containers"Web Interface:
- Fill in form fields
- Click "Add Command" button
All modes check for duplicate commands before adding:
- Exact command match
- Case-sensitive comparison
- Prevents duplicate entries
Found 1 result(s) for: postgresql replication
══════════════════════════════════════════════════════════════
ID: 785
Description: Postgresql Replication check on Master Server
Command:
$ docker exec POSTGRESQL psql -U ricardo -c "SELECT * FROM pg_stat_replication;"
──────────────────────────────────────────────────────────────
{"id": 785, "key": "$ docker exec POSTGRESQL psql...", "data": "Postgresql Replication check..."}----------------------------------------------------------------------
# ID: 785
# Description: "Postgresql Replication check on Master Server"
# Command: $ docker exec POSTGRESQL psql -U ricardo -c "SELECT * FROM pg_stat_replication;"
All modes use the same PostgreSQL backend:
- Shared database connection
- Consistent data across all interfaces
- Real-time updates
- ACID compliance
Configuration: .env file
DB_HOST=192.168.1.4
DB_PORT=5432
DB_USER=user_name
DB_PASS=password
DB_NAME=database_name
TB_NAME=scmdDaily Development:
scmd> show me docker commands
scmd> kubernetes deployment
scmd> /add kubectl scale deployment myapp --replicas=3 | Scale deployment
Learning & Exploration:
scmd> how to use git rebase
scmd> postgresql backup commands
scmd> /list
Shell Scripts:
#!/bin/bash
result=$(scmd.exe --search "backup")
echo "$result" | jq '.[] | .key'Automation:
# Add command from script
scmd.exe --save "$(cat command.txt)" "$(cat description.txt)"Team Knowledge Base:
- Share commands across team
- Browse commands visually
- Add commands via form
- Access from any device
Documentation:
- Embed in internal wiki
- Reference in documentation
- Share via URL
- Read-only mode for viewers
scmd.exe --ssl -port 443 certificate.pem privkey.pem
scmd.exe --ssl -port 443 -service certificate.pem privkey.pemRun without launching browser:
scmd.exe --web -port 3333 -service
scmd.exe --ssl -port 443 -service cert.pem key.pemDisable command addition:
scmd.exe --web -block
scmd.exe --web -port 8080 -blockAll modes automatically detect and format code:
- Functions
- Scripts
- Multi-line commands
- Proper indentation
- Fast startup (single DB connection)
- Instant searches
- No overhead between commands
- Efficient for multiple queries
- Quick execution
- Minimal overhead
- Ideal for scripting
- One connection per command
- Persistent connection
- Multiple concurrent users
- Efficient connection pooling
- Suitable for team use
All features work with PostgreSQL:
- Same command syntax
- Same search patterns
- Same output formats
- Enhanced performance
- Better scalability
Planned features:
- Command history (interactive mode)
- Auto-completion
- Fuzzy search
- Command editing
- Batch operations
- Export/import
- Favorites/bookmarks
- API endpoints
- Command versioning
- Tags and categories
- Configure database - Edit
.envfile - Choose your mode:
- Interactive:
scmd.exe -i - CLI:
scmd.exe --search "pattern" - Web:
scmd.exe --web
- Interactive:
- Start searching!
- INTERACTIVE_MODE.md - Interactive CLI guide
- POSTGRESQL_MIGRATION.md - Database setup
- QUICKSTART.md - Quick start guide
- UPGRADE_SUMMARY.md - What's new
- README.md - Main documentation