Links
AddThe Scientific Python Development Environment. Spyder is a powerful scientific environment written in Python, for Python, and designed by and for scientists, engineers and data analysts. It offers a unique combination of the advanced editing, analysis, debugging, and profiling functionality of a comprehensive development tool with the data exploration, interactive execution, deep inspection, and beautiful visualization capabilities of a scientific package.
wrangle data.
sq is a command line tool that provides jq-style access to structured data sources: SQL databases, or document formats like CSV or Excel. It is the lovechild of sql+jq.
The Database Toolkit for Python.
SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.
It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language.
SQL Buddy β Web based MySQL administration
sqlcake is an automatic SQL injection exploitation kit written in Ruby. It's designed for system administration and penetration testing.
Defog's SQLCoder is a state-of-the-art LLM for converting natural language questions to SQL queries.
Transform SQL queries into interactive visual flow diagrams.
SQL Crack is a VS Code extension that visualizes SQL queries as interactive execution flow diagrams. Understand complex queries at a glance, track data lineage across your entire workspace, and identify optimization opportunities with professional-grade visual analysis.
Idempotent schema management for MySQL, PostgreSQL, SQLite, and SQL Server.
sqldef is a CLI tool for diffing two SQL schemas. You can use it to manage the migration of RDBMSs using regular SQL DDLs.
Supported databases: MySQL, MariaDB, TiDB, PostgreSQL, SQL Server, and SQLite3.
A modular SQL linter and auto-formatter with support for multiple dialects and templated code.
SQLFluff is an open source, dialect-flexible and configurable SQL linter. Designed with ELT applications in mind, SQLFluff also works with Jinja templating and dbt. SQLFluff will auto-fix most linting errors, allowing you to focus your time on what matters.
Python SQL Parser and Transpiler.
SQLGlot is a no-dependency SQL parser, transpiler, optimizer, and engine. It can be used to format SQL or translate between 31 different dialects like DuckDB, Presto / Trino, Spark / Databricks, Snowflake, and BigQuery. It aims to read a wide variety of SQL inputs and output syntactically and semantically correct SQL in the targeted dialects.
A user friendly TUI for SQL databases. Written in python. Supports SQL server, Mysql, PostreSQL and SQLite, Turso and more.
The lazygit of SQL databases. Connect to Postgres, MySQL, SQL Server, SQLite, Supabase, Turso, and more from your terminal in seconds.
Related contents:
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day. More Information...
Related contents:
- SQLite File Format Viewer.
- SQLite Transactions and Virtual Tables @ Misframe.
- A faster way to copy SQLite databases between computers @, alexwlchan.
- Scaling SQLite to 4M QPS on a single server (EC2 vs Bare Metal) @ Expensify.
- PSA: SQLite WAL checksums fail silently and may lose data @ blag.
- Lessons learned from building a sync-engine and reactivity system with SQLite @ Antoine's blog.
- From 19k to 4.2M events/sec: story of a SQLite query optimisation @ mnt.io.
- SQLite Is ULTIMATE Choice For 99% of Projects @ DevOps Toolbox's YouTube.
- Subtleties of SQLite Indexes @ Evan Schwartz.
- SQLite concurrency and why you should care about it @ Jellyfin.
- 100000 TPS over a billion rows: the unreasonable effectiveness of SQLite @ anders murphy.
- The Silent Standard: Why the Worldβs Most Deployed Database Is Killing the Custom File Format @ WebProNews.
- SQLite JSON Superpower: Virtual Columns + Indexing @ DB Pro.
- I don't buy SQLite in the cloud @ Monroe Clinton.
- SQLite 3.52 Released With WAL Corruption Fix and CLI Improvements @ linuxiac.
- Gotchas with SQLite in Production @ AnΕΎe's Blog.
- Modern SQLite: Features You Didnβt Know It Had @ slicker.me.
- SQLite is All You Need for Durable Workflows @ Obelisk.
- SQLite improving performance with pre-sort @ anders murphy.
- Detecting Full Table Scans With SQLite @ Tenderlove Making.
- SQLite should have (Rust-style) editions @ Mort's Ramblings.
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.
Related contents:
A fast, lightweight replacement for SwiftData, powered by SQL and supporting CloudKit synchronization.
This tool helps you explore the SQLite file format internals according to the official specification. It's designed for developers and database enthusiasts who want to understand the internal structure of SQLite database files.
Create custom SQLite functions in JavaScript. Extend your database with scalars, aggregates, window functions, and collations directly in JavaScript.
SQLite-JS is a powerful extension that brings JavaScript capabilities to SQLite. With this extension, you can create custom SQLite functions, aggregates, window functions, and collation sequences using JavaScript code, allowing for flexible and powerful data manipulation directly within your SQLite database.
Visual tool to explore SQLite databases page-by-page, the way they're stored on disk and the way SQLite sees them. A small GUI application built in redbean that lets you explore your SQLite databases "page by page" the way SQLite sees them.
Smart Edge Databases with Cloud Sync and Intelligence.
SQLiteSync is a local-first SQLite extension using CRDTs for seamless, conflict-free data sync and real-time collaboration across devices.
Related contents:
A vector search SQLite extension that runs anywhere!
automatic SQL injection and database takeover tool.
SQLmap is an open source penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers.
A web-based tool to easily generate customizable SQLMap commands for testing SQL injection vulnerabilities. Features include target configuration, connection options, detection levels, and various SQL injection techniques. Perfect for penetration testers and security enthusiasts.
Efficient data transformation and modeling framework that is backwards compatible with dbt.
SQLMesh is a next-generation data transformation framework designed to ship data quickly, efficiently, and without error. Data teams can efficiently run and deploy data transformations written in SQL or Python with visibility and control at any size.
Related contents:
A Detective SQL Game
SQL Noir is an interactive mystery-solving game where you crack cases by writing SQL queries.
Open-source low-code web application framework. Create full websites writing only simple database queries.
SQLpage is an SQL-only webapp builder. It is meant for data scientists, analysts, and business intelligence teams to build powerful data-centric applications quickly, without worrying about any of the traditional web programming languages and concepts.
With SQLPage, you write simple .sql files containing queries to your database to select, group, update, insert, and delete your data, and you get good-looking clean webpages displaying your data as text, lists, grids, plots, and forms.
SQL language server written in Go.
sqls aims to provide advanced intelligence for you to edit sql in your own editor.
sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
You're a DBA, sysadmin, or developer who manages Microsoft SQL Servers. It's your fault if they're down or slow. These tools help you understand what's going on in your server.
a free educational game that's inspired by Netflix's Squid Game, SQL Murder Mystery, and a few other SQL Games we love to play.
A consistent code style guide for SQL to ensure legible and maintainable projects.
Watch SQL traffic in real-time with a TUI. Real-time SQL traffic viewer β proxy daemon + TUI / Web client.
sql-tap sits between your application and your database (PostgreSQL, MySQL, or TiDB), capturing every query and displaying it in an interactive terminal UI. Inspect queries, view transactions, and run EXPLAIN β all without changing your application code.
Related contents:
A (somewhat opinionated) list of SQL tips and tricks that I've picked up over the years.
There's so much you can you do with SQL but I've focused on what I find most useful in my day-to-day work as a data analyst and what I wish I had known when I first started writing SQL.
Free Online SQL Diagram & ERD Generator.
ER diagram generator. Paste CREATE TABLE statements and get a clean, interactive ERD β runs 100% in your browser, nothing uploaded
DΓ©veloppΓ© avec une mutuelle, Square permet Γ tous vos employΓ©s dβavoir, sur un mΓͺme Γ©cran, toutes les informations importantes de votre adhΓ©rent : Famille, prestations, cotisations, contrats, documents, emails Γ©changΓ©s, devis, connexion Webβ¦
Telling tales on you for leaking secrets!.
Squealer scans a git repository or filesystem for secrets that are being leaked deep within the commit history.
Squest is a self-service portal that works on top of Red Hat Ansible Automation Platform/AWX.
Optimising Web Delivery.
Squid is a caching proxy for the Web supporting HTTP, HTTPS, FTP, and more. It reduces bandwidth and improves response times by caching and reusing frequently-requested web pages. Squid has extensive access controls and makes a great server accelerator. It runs on most available operating systems, including Windows and is licensed under the GNU GPL.
Looking to add some premium squircley goodness to add to your designs? Squircley is all you need to start creating beautiful organic shapes ready to use for logos, icons and background images.
The generator exports SVG files which can be copied straight to the clipboard for dropping into your HTML / CSS or downloaded to your computer ready to use in your design software of choice (Figma, Sketch, Framer, XD, etc)
Squirrel Servers Manager (SSM). A user-friendly, UI/UX focused server & configuration management tool.
Powered by Ansible & Docker.
SQuirreL SQL is an open-source Java SQL Client program for any JDBC compliant database
Make images smaller using best-in-class codecs, right in the browser.
Squoosh is an image compression web app that reduces image sizes through numerous formats. Squoosh does not send your image to a server. All image compression processes locally.
SRCL is an open-source React component and style repository that helps you build web applications, desktop applications, and static websites with terminal aesthetics. Its modular, easy-to-use components emphasize precise monospace character spacing and line heights, enabling you to quickly copy and paste implementations while maintaining a clean, efficient codebase.
Open-Source Kubernetes Desktop Client Built in Rust. The Kubernetes control room for engineers and AI agents.
Investigate, analyse, and take safe action across Kubernetes clusters from one local-first desktop workspace, built with a pure-Rust core. Backend capabilities are also available to AI agents through MCP.
NixOS profiles for servers.
SrvOS is a collection of NixOS modules that are optimized for servers. They includes many lessons that we gained over the years while deploying servers for our customers. As we like to share, we hope that this project will be useful to you.
π₯ Universal Server API based on web platform standards. Works seamlessly with Deno, Bun and Node.js.
standalone SSH server that connects you to your Docker containers.
ssh2docker is a SSH server that can create new Docker containers and/or
join existing ones, with session, and dynamic configuration support.
It is an alternative to chroot.
SSH3: faster and rich secure shell using HTTP/3.
SSH3 is a complete revisit of the SSH protocol, mapping its semantics on top of the HTTP mechanisms. In a nutshell, SSH3 uses QUIC+TLS1.3 for secure channel establishment and the HTTP Authorization mechanisms for user authentication.
Unexpected Exposures in SSH. SSHamble is a research tool for SSH implementations.
SSHamble simulates potential attack scenarios, including unauthorized remote access due to unexpected state transitions, remote command execution in post-session login implementations, and information leakage through unlimited high-speed authentication requests. The SSHamble interactive shell provides raw access to SSH requests in the post-session (but pre-execution) environment, allowing for simple testing of environment controls, signal processing, port forwarding, and more.
SSH server & client security auditing (banner, key exchange, encryption, mac, compression, compatibility, security, etc)
Related contents:
SSH has many features which are helpful when working regularly with files on remote servers; together they can give a vast increase in productivity over the bare use of SSH. If you regularly use SSH, itβs worth spending a little time learning about these and configuring your environment to make your life easier.
copy/paste, everywhere. Native encrypted clipboard sync over SSH for macOS and Linux.
Peer-to-peer clipboard sync over SSH for macOS and Linux. Copy anything on one machine, paste on another. No relay, no account, no new ports. Written in Rust ackchyually.
Run sequential command(s) on a group of SSH servers.
SSH Commander is a powerful, colorful command-line tool for executing commands across multiple SSH servers simultaneously. It supports both password and key-based authentication, custom ports, and can execute both single commands and command files.
SSH server & client security auditing (banner, key exchange, encryption, mac, compression, compatibility, security, etc)
This free tool audits the configuration of an SSH server or client and highlights the areas needing improvement.
Too many admins overlook SSH configuration when setting up new systems. Unfortunately, the defaults for many operating systems are optimized for compatibility, not security.
π§βπ» SSH connection manager with a TUI interface.
This application does not modify your existing SSH configuration files. Host settings can be spread across multiple files referenced by Include directives (and between system and user configs), so automatic editing is unreliable.
Related contents:
SSHM is a beautiful command-line tool that transforms how you manage and connect to your SSH hosts. Built with Go and featuring an intuitive TUI interface, it makes SSH connection management effortless and enjoyable.
Related contents: