code insights: deploy TimescaleDB in dev and CI environments

Created by: slimsag

(See #17218 (closed) for general plan / explanation of the work being done on code insights.)