A stored procedure is a precompiled collection of one or more SQL statements or procedural logic, stored in a database, and assigned a name. It can be called and executed multiple times by referencing its name. Stored procedures are used for code modularity, improved performance, and security in database management systems. They are particularly common in SQL-based databases like MySQL, Oracle, and Microsoft SQL Server.