Disclosed herein are systems and methods for attachable-and-detachable database sessions. In an embodiment, a database platform receives an attachment request from a client during a connection-specific database session that is set as a current database session for the client at the database platform, requesting that the client attach to an attachable-and-detachable database session that is maintained in data storage by the database platform. The database platform sets, in response to receiving the attachment request, the attachable-and-detachable database session as the current database session for the client at the database platform. The database platform determines that the client has detached from the attachable-and-detachable database session, and continues to maintain the attachable-and-detachable database session in the data storage.